I'm doing an ado query on an access table
I want all the records on the left with details from the right
e.g
Select R.*,g.* from reservation r
left outer join guest g on r.reservationid = g.lsreservationid
I get all my res records but the problem is where there is one record on the
right(guest) being used in multiple records on the left. Only one of the
records returned will have the right (guest) details.
tried using "full inner join" and "full outer join" but Access complained
"unspecified error".
anyone got ideas on solving this. Thanks
Does Access have a problem with "Full inner join"?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
