Query not to show null fields

[sibbbra]

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 ;;;;;

 

[Eugene-LS]

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.

SELECT Order_ID, Order_Date, Amount_Cash_Customer, Amount_Cash_Supplier
FROM Orders
WHERE
     (Amount_Cash_Customer = 1000)
     OR
     (Amount_Cash_Supplier = 400);

 

[MajP]

I want that the order ID 144 and 145 should show only , with 1000 and 400

Although @Eugene-LS solution is correct, I have to assume that is not really what you want. Seems pretty specific and not of much use.

Maybe you really are looking to return records where you have a value in either field greater than 0? FYI you do not have any Null values. You have values of 0. Very different.

WHERE Amount_Cash_Customer > 0 or Amount_Cash_Supplier > 0

 

[arnelgp]

should be OR:

SELECT Order_ID, Order_Date, Amount_Cash_Customer, Amount_Cash_Supplier
FROM Orders
WHERE
Amount_Cash_Customer <> 0
OR
Amount_Cash_Supplier <> 0;

 

[arnelgp]

Although @Eugene-LS solution is correct

it is not.

 

[MajP]

it is not.

Why not, besides the logic?

 

[sibbbra]

Although @Eugene-LS solution is correct, I have to assume that is not really what you want. Seems pretty specific and not of much use.

Maybe you really are looking to return records where you have a value in either field greater than 0? FYI you do not have any Null values. You have values of 0. Very different.

WHERE Amount_Cash_Customer > 0 or Amount_Cash_Supplier > 0

So kind of you. It helped

 

[sibbbra]

it is not.

so kind and helpful. problem solved.
Thanx to all

 

[Eugene-LS]

it is not.

Why not, besides the logic?

I did EXACTLY what TC asked (although there were doubts) and thought that couple digits and equal signs between them - he will be able to replace himself
Over.

 

[arnelgp]

Why not, besides the logic?

i am sure he uses And not Or on the criteria (must be my eyes.. or his fast fingers)

 

[Eugene-LS]

i am sure he uses And not Or on the criteria (must be my eyes.. or his fast fingers)

You 're right , but I quickly corrected my text ...

 

[MajP]

You 're right , but I quickly corrected my text ...

Oh, I Understand now. Did not see the And only the Or.

 

[Eugene-LS]

You always have to read between the lines when answering questions

You are absolutely right.
Thank you so much for your kind advice and training.
I think you're being too kind to me.

 

[Eugene-LS]

Oh, I Understand now. Did not see the And only the Or.

I keep forgetting to write myself a poster:
"Before you turn on your computer - Don't forget to turn on your brain!"

 

[Eugene-LS]

he desire to help lives within all of us who answer questions here

I agree with you again!
But there is also a "human factor" - because we are all human...
...
I think the "human factor" makes everything more interesting...