Combine tables

[moustafa]

Good Morning every one;
i have two tables as the following :
table 1 fields : customer_name, type , qty , price , total , delivery_no , delivery_date , grade

table 2 field : customer_name, type , qty , price , total , delivery_no , delivery_date , grade

** i need to make query that get the following data from both tables **
Customer _ name , qty , total , type , grade , delivery_date (by month ) .

** please some help ....

 

[pr2-eugin]

Why is that you have two tables with similar structure ?? Did you try using UNION Query?

 

[moustafa]

dear pr2 ;
thanks for your respond ;
the two tables has different data
i need to union them
but i dont know the sql statments;

 

[pr2-eugin]

Did you read through the link I provided? The code should be something like.

SELECT table1.fieldName1, table1.fieldName2, table1.fieldName3 FROM table1
UNION
SELECT table2.fieldName1, table2.fieldName2, table2.fieldName3 FROM table2;