> So... > Select n.uid, n.name from names_table n > LEFT JOIN exclude ON n.uid = exclude.n_uid > WHERE exclude.n_uid IS NULL;
OK... this works, but I thought I would go a bit further... I have added a field in the exclude-table, "cat_id". This shows which catalogue the names have been excluded from. I want to do the operation above, but limit it to only the current catalogue, namely 16. I tried: Select n.uid, n.name from names_table n, exclude e1 LEFT JOIN exclude ON n.uid = exclude.n_uid WHERE exclude.n_uid IS NULL AND e1.catid=16; I also tried putting some left joins in aswell, but I didn't get them to work. Am I mixing too much into the same query? // Michelle __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php