Gary Croxford
asked on
Query that Concatenates Data from Two Tables
Thank you for looking at my question,
I have two tables SO_Header_Live and SO_Header_Posted.
SO_Header_Live
SO_Number,
SO_Date,
Customer,
SO_CostTotal,
SO_SalesValueTotal
SO_Header_Posted
SO_Number,
SO_Date,
Customer,
SO_CostTotal,
SO_SalesValueTotal
I need a single query that returns the SO_Number and SO_SalesValueTotal from both tables between two dates.
Any help you can provide would be greatly appreciated.
I have two tables SO_Header_Live and SO_Header_Posted.
SO_Header_Live
SO_Number,
SO_Date,
Customer,
SO_CostTotal,
SO_SalesValueTotal
SO_Header_Posted
SO_Number,
SO_Date,
Customer,
SO_CostTotal,
SO_SalesValueTotal
I need a single query that returns the SO_Number and SO_SalesValueTotal from both tables between two dates.
Any help you can provide would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER