query

Hi,
I have two tables ,the first record of table 1 matches the first record of table 2 but there is no relationship given. how do i make a join . is this possible by a select statement.i got it only through a procedure which is more tedious.
please let me know the same at the earliest.........

Regards ,
Ramya
:D

Maybe some example data?

What do you mean by "first record"? Unless you order by some column(s), the rows in table MUST be regarded as being in a random, changing order.

Yes man, DaPi is right. These are not SAS datasets, these are database tables. You can never rely on the order the records are returned unless you use order by.