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.

 

[Pat Hartman]

I did EXACTLY what TC asked (although there were doubts)

You read the first half of the question but not the second. The second half plus common sense would have suggested that you give some weight to your doubts.

You always have to read between the lines when answering questions and don't just blindly answer the specific question

 

[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!"

 

[Pat Hartman]

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

 

[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...