SQL Query

[harpreett.singhh@gmail.co]

Hi,

I am trying to retrieve some records via a Union SQL Query. Problem is that the area field shows as ID numbers not the actual values which are in the next column of area table. Normal queries run as normal (Shows area values instead of IDs)

When I setup the query it shows the names but in the SQL Query it shows ID numbers of the same fields.



Any suggestions how to show texts instead of ID's?

This area table has two fields ID; Area.

SELECT [Audit Register Query 1-44].[Audit Number], [Audit Register Query 1-44].[CEP No], [Audit Register Query 1-44].[CEP Name], [Audit Register Query 1-44].[Audit Date], [Audit Register Query 1-44].Percent, [Audit Register Query 1-44].[Month Date], [Audit Register Query 1-44].[Area], [Audit Register Query 1-44].[CEP Final Status]
FROM [Audit Register Query 1-44]


UNION ALL
SELECT [Audit Register Query 45-117].[Audit Number], [Audit Register Query 45-117].[CEP No], [Audit Register Query 45-117].[CEP Name], [Audit Register Query 45-117].[Audit Date], [Audit Register Query 45-117].Percent, [Audit Register Query 45-117].[Month Date], [Audit Register Query 45-117].[Area], [Audit Register Query 45-117].[CEP Final Status]
FROM [Audit Register Query 45-117]


UNION ALL SELECT [Audit Register Query 118 Onwards].[Audit Number], [Audit Register Query 118 Onwards].[CEP No], [Audit Register Query 118 Onwards].[CEP Name], [Audit Register Query 118 Onwards].[Audit Date], [Audit Register Query 118 Onwards].Percent, [Audit Register Query 118 Onwards].[Month Date], [Audit Register Query 118 Onwards].[Area], [Audit Register Query 118 Onwards].[CEP Final Status]
FROM [Audit Register Query 118 Onwards];




Regards

[June7]

Have to join tables. Options:

1. Join Area table to each of the other tables in each SELECT line of UNION query.

2. Join the UNION query to the Area table