Hello,
SELECT *
FROM TABLE_A AS A
LEFT JOIN TABLE_B AS B ON A.A_ID = B.A_ID
is not something i am looking for. as this query repeats the value from table A.
I do not want to repeat my master information from Table A. And as to answer
Another question. What defines the first row in Table B? Remember there is no explicit guarantee that rows return by a SELECT statement are returned in the order in which the rows were inserted.
We can have first row from Table B or who's create date time stamp is first.
does it make sense?.?
Thanks for makin efforts for me.