hi,
I ahve a simple query:
I want that the order ID 144 and 145 should show only , with 1000 and 400 amount and the last 2 columns with null values to be dropped.
It should show as
the SQL is
SELECT Orders.Order_ID, Orders.Order_Date, Orders.Amount_Cash_Customer, Orders.Amount_Cash_Supplier
FROM Orders;
;;;;; please help, how to do that ;;;;;
I ahve a simple query:
I want that the order ID 144 and 145 should show only , with 1000 and 400 amount and the last 2 columns with null values to be dropped.
It should show as
the SQL is
SELECT Orders.Order_ID, Orders.Order_Date, Orders.Amount_Cash_Customer, Orders.Amount_Cash_Supplier
FROM Orders;
;;;;; please help, how to do that ;;;;;