>Hi,
>
>I know the title is not very clear and what I am looking for should not be hard. But I just can't get it (blame it on Friday or spring).
>
>Anyway. A SQL Select creates a query with one table JOINed with another. My question is, how can I determine which record in the query came from the 1st or the 2nd table in the JOIN? I realize that at least one record in the query came from both tables. So if I can determine this (joint) record, it would be helpful too.
>
>Thank you in advance.

Dmitry,

Can you please post your SQL or at least prototype, so we would be able to see, what do you mean?

I'm thinking it's impossible to find out this info, but I need to see some SQL to better understand, if this is possible or not.