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.