* sulewski
[...]
> What I need is all records in table 1 that will
> not link to table 2 such that relid=rid and vid=46
Sounds like a job for LEFT JOIN...?
Join to the rows you do NOT want with a left join, and put as a condition in
the WHERE clause that a joined column IS NULL. Something like this:
SELECT tab1.*
FROM tab1
LEFT JOIN tab2 ON
tab2.rid=tab1.id AND
tab2.vid=46
WHERE
tab2.rid IS NULL
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
