query

[rumcool]

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

[marist89]

Maybe some example data?

[DaPi]

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.

[ddrozdov]

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.