That's what an LEFT OUTER join does, by definition. You want to do an INNER
join (i.e. return only the rows where there is a match between the two tables).
Joe
Daniel J O'Keefe wrote:
> The query below returns all records in the left table (tblDocMaster). The
> table on the right (tblDocDiagnosisDate) does not contain any records. Even
> if I add one record to the table on the right with an abstractID, I still
> get all records on the left table.
>
> SELECT a.*, b.*
> FROM tblDocMaster as a left outer join tblDocDiagnosisDate as b
> on a.abstractID = b.abstractID AND a.abstractID = 1
>
> Any ideas?
>
> Dan
>
> ------------------------------------------
> Dan O'Keefe
> TriPoint Technologies
> [EMAIL PROTECTED]
> 954.575.0097 office
> 954.675.3115 cell
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
