Home Forums SQL Server 7,2000 T-SQL Not in RE: Not in

  • June 19, 2003 at 9:55 am

    #462187

    Select a.col1, a.col2, b.col1, b.col2 from tablea NOT EXIST (select 1 from tableb b where a.col3=b.col3)