.. to query from 2 table that are being joined together and know in which table the data being found?
well, yeah. alias the columns<BR><BR>SELECT a.something as something_a, b.something as something_b from tblsomething INNER JOIN tblSomethingElse ....
how to know in which coloumn the data being found?
you ALIAS the column.