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
