Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Joining two Tables
- Thread starter Edwardjm
- Start date
When you say it only works when there is matching data in the second table, by "works" I assume you mean you don't get any data.
If you want to return all of the rows from the first table, and matching rows if they exist from the second table, what you want is an outer join.
[tt]select TableA*, TableB.WhateverColumns
from TableA left join TableB on
(TableA.FK = TableB.PK) [/tt]
If you want to return all of the rows from the first table, and matching rows if they exist from the second table, what you want is an outer join.
[tt]select TableA*, TableB.WhateverColumns
from TableA left join TableB on
(TableA.FK = TableB.PK) [/tt]
- Status
Similar threads
- Locked
- Question