G
Guest
Hi,
I have written an SQL query as follows :
SELECT [Product_code], [Net], [Pstg_date]
FROM [REVENUE 2006]
UNION ALL SELECT [Product_code], [Net], [Pstg_date]
FROM [REVENUE 2007];
However, I also want to include information in the query which is referenced
from other tables. (e.g. the names of the products from the product table,
the period from the dates table) Is there anyway of doing this ?
Thanks in advance
Pete
I have written an SQL query as follows :
SELECT [Product_code], [Net], [Pstg_date]
FROM [REVENUE 2006]
UNION ALL SELECT [Product_code], [Net], [Pstg_date]
FROM [REVENUE 2007];
However, I also want to include information in the query which is referenced
from other tables. (e.g. the names of the products from the product table,
the period from the dates table) Is there anyway of doing this ?
Thanks in advance
Pete