Joining tables where not all tables have relevant records [message #8831] |
Mon, 29 September 2003 08:34 |
Mark Fretwell
Messages: 2 Registered: September 2003
|
Junior Member |
|
|
Hello all,
I am trying to join several tables together where some of the tables may not have a record for all the records in the other tables. I need to return the values where this happens, as well as all the others e.g;-
Table 'one'
UID Colour
123 Yellow
456 Black
789 Orange
Table 'two'
UID Points
123 2
456 7
Table 'three'
UID Favourite
123 John
789 Sam
I can get
UID Colour Points Favourite
123 Yellow 2 John
from a standard
where one.uid = two.uid and two.uid = three.uid
type of query
but I need
UID Colour Points Favourite
123 Yellow 2 John
456 Black 7
789 Orange Sam
as my results
All help gratefully accepted.
Regards,
Mark.
|
|
|
|