SQL Server Guru!!!!!!!!!!1

[DiscoStu]

ooh, ooh, can we ask Access questions?

[DiscoStu]

Will someone be able to explain the difference between an inner and an outer join to me?

[El_Diablo]

Will someone be able to explain the difference between an inner and an outer join to me?

The other day I was putting on my linen bottoms (sunny day, in the garden) when my inner join on the left leg went and I was mighty miffed.

That kinda join?

[DiscoStu]

The other day I was putting on my linen bottoms (sunny day, in the garden) when my inner join on the left leg went and I was mighty miffed.

That kinda join?

Yes, I could ask them for advice on how to fix the inner join in your trousers.

[El_Diablo]

Yes, I could ask them for advice on how to fix the inner join in your trousers.

Does that mean it would be normalised?

[DiscoStu]

Does that mean it would be normalised?

Don't start getting technical on me

[DieScum]

An inner join is joining the insides of tables, and outer join (or 'outer') is joining the outside bits.

At least that is how I understand it.

Use both if in doubt.

[DiscoStu]

An inner join is joining the insides of tables, and outer join (or 'outer') is joining the outside bits.

At least that is how I understand it.

Use both if in doubt.

What about trouser seams?

[DieScum]

I think you have misunderstood the topic DiscoStu. This is about databases not trousers.

[El_Diablo]

Don't start getting technical on me

Sorry sir I am suitably chastened