OK, I've heard a lot about inner joins and outer joins but don't really 
know them or how to use them.

I've actually been using SQL for 10 years now, but never managed to 
completely figure this out.


Lets say I have (2) tables - (2) column each

Person				Limbs
Index	Name			PersonIndex	Type



Now, I would normally write a SQL statement like this:

select L.Type from Person P, Limbs L where L.PersonIndex = P.Index and 
P.Name = 'Bones'

This *works*, but somehow I feel that this is where the JOIN should come in.


Should a JOIN be used here?
Does it matter?


Thanky..... Tom

Post a reply to this message