Oops, you are correct. I missed a "not" in the original post.
-Sheeri
On 10/27/05, Brent Baisley <[EMAIL PROTECTED]> wrote:
> You would want to do a left join and only keep the null values.
>
> SELECT tableA.*
> FROM tableA
> LEFT JOIN tableB ON tableA.recordID=tableB.recordID
> WHERE tableB.rec
You would want to do a left join and only keep the null values.
SELECT tableA.*
FROM tableA
LEFT JOIN tableB ON tableA.recordID=tableB.recordID
WHERE tableB.recordID IS NULL
On Oct 27, 2005, at 6:35 AM, Christopher Molnar wrote:
If I have two similar tables, with identical columns how would I
