> Hi, > > select table1.col_name FROM table1 left join table2 > on table1.col_name = table2.colnmae where table2.clnmae is null > > Rich > Inbal Ovadia wrote: > >> Hi >> i want to do in mysql query like that: >> >> SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2) >> >> how can i do that? >> thanks >> >> >> >> --------------------------------------------------------------------- >> 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 >> >> > > >
--------------------------------------------------------------------- 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