I realize that, but it was ignoring limiting the recordset to abstractID =
1.
Here is the solution to the problem:
SELECT a.*, b.*
FROM tblDocMaster as a left outer join tblDocDiagnosisDate as b
on a.abstractID = b.abstractID
WHERE a.abstractID = #URL.abstractID#
Dan
>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
------------------------------------------
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
