Hi
'SalesOrders' archivedSalesOrders'
Above two tables will have a Sales Order ID or ID field which will have common values in both the tables what you need to do is join both the tables based on that field also you need alias names created for the tables as the column names are same from both the tables
So your sql will be
Select
'Sord.OrderNumber',
'Sord.OrderDate',
'Sord.OrderCost',
'Sord.OrderTotal'
From SalesOrder Sord
INNER JOIN archivedSalesOrders ASord
WHERE Sord.id = ASord.id
I donn which tables the column names you want to use,above i have just used alias name from SalesOrder table Sord for sample,you will need to alias the column names as you want to get from the correct table.
Cheers
Rahul
IP Logged
