Problem with SQL Statement
Posted: Fri Dec 10, 2010 7:51 am
Hi guys,
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.
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.