To know Table name in Join Query

[mmb]

I have called a Join Query from MS-Access.

Now I want to know the Table name of each column.
If this is possible then HOW?

Urgent help needed.

 

[ArizonaRedneck]

in the join you can find it here:

 SELECT [color=red]A[/color].BusinessName, [color=red]B[/color].GrandTotal 
FROM tblAccount [color=red]A[/color] INNER JOIN
tblBilling [color=red]B[/color] ON A.ID = B.MainID

if you need it after the join, name them differently:

SELECT A.BusinessName [color=red]AS tblAccountBusinessName[/color], B.GrandTotal [color=red]AS tblBillingGrandTotal[/color]
FROM tblAccount A INNER JOIN 
tblBilling B ON A.ID = B.MainID

the above statement returns 2 columns. One named tblAccountBusinessName and one named tblBillingGrandTotal

hope that is what you were looking for

 

[mmb]

I Want To Know The Table Names Of Each Column

Thanks for the reply.

But this is not I am looking for. I WANT TO KNOW THE TABLE NAMES OF EACH COLUMN from the Result the join query has put forward.

Help me out pls

 

[ArizonaRedneck]

you need to use my second example. when you do a SQL join, it creates a virtual table. The Result set of the query thinks that all of the fields are from the same table. If you need to keep track of what field is from what original table, rename them to something unique using the AS statement.

 

[levyuk]

I did something like this in a java program once, I think i used the metadata from the table to find the column names.

 

[mmb]

by metadata u mean like selecting the tables of the join query individually and then comparing/finding the column names ?

 

[levyuk]

No, To be honest I can't really remember much about it. I didn't like Java so didn't pay much attention to the lecturers.