-
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
ramya
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|