I'm using mysql 3.23 on red hat 6.1 I want to select * from tablea and tableb where columna in tablea is the same as columnb in tableb, but columna1 in tablea DOESN'T appear in columnb in tableb. I tried select a.* from tablea as a,tableb as b where a.cid <> b.uid limit 30; it gave me the first line of tablea 30 times and the cid of that table EXISTS in tableb. Please help Tomer Grassyani. Internet Driver.
--------------------------------------------------------------------- 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