hello, i need help writing a sub query... i have 2 tables, tab1 has 600 rows and tab2 has 271 rows so i need minus tab2 rows from tab1 and display the remaining 329 rows...
tab1 has 8 columns of which i need to display all rows, tab2 has 10 columns of which 6 column match 6 columns on tab1...so i wrote something like this and it does not work...
select col1, col2, col3, col4, col5, col6, col7, col8, col8
from tab1 t1
where t1.col1 not in (select t2.col1
from tab1 t2, tab2 t3
where t2.col1=t3.col1 and
can you please help me with this sub query...