Problem with SQL Statement
I have one problem,
Table A (contains 100 records), just one identifier
Table B (contains 500 records), just two identifiers
What i want is, there must be a SQL statement....which offer me
It must take first record from TABLE A, and check that into Table B...if exists then display that records there. and the show must continue till 100 records (till Tables moves to end)
Plz help me finding such statement i can execute as SQL statement.
many thanks in advance.
select tablea.col1 from tablea left join tableb on tablea.col1 = tableb.col1 WHERE tableb.col2 IS NOT NULL;
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread