Search results

but i have one more question how can i group and sum the quantity for every customer and group the delivery date by monthe ( i want the total quantity for every customer in the month ) thanks again

thanks thanks thanks it's work correctly

SELECT Customer_Name, Quantity, Delivery_Date FROM WINDMILL UNION ALL SELECT Customer Name, Quantity, Delivery_Date FROM CRUSHER GROUP BY Customer_Name, Delivery_Date;

thanks it's work after i removed the bracket but when i add the group by and order by it;s not work again >>> may be because the ; i did not know where i should type it

the code not work correctly it;s give me message ( error in from clause ) note: i al ready add the true names for the tables .... thanks for you interesting...

HOW CAN I MERGE THE DATA BETWEEN THESE TWO QUERIES AND VIEW IT IN ONE QUERY WITHOUT ANY DUPLICATED IN CUSTOMERS THANKS:confused::confused::confused::confused:

About query Hi every body i have two queries with no primary key in the original tables because the original tables in ecxel sheet and i linked this sheet to my db ?? The two table have the same columns names cutomer name, qty, date ?? How can i group the two queries in on query that show...

Re: Very ARGENT Excuse me where i will type that code

I have two tables first table : customer name,QUANTITY ,delivery date,product type second table : customer name,QUANTITY ,delivery date,product type i want to make query to sum the QUANTITY from the two tables and group by customer name and delivery date can any one help me to do this ...

It's nice to join to this site:)