Loading

How to get all order ID which not payed in SQL Server 2008?

Doudy

13y1.8k

Hi , I want to get all order id numbers for selected customer which not payed till now, my data show as following:

What I want is Write a SELECT statement that answers this question:

select orderID from order where customer id = @custID and Total cashmovementValue for current order id is less than total (sold quantity * salePrice ) for current order id.

How to do it?

Thanks.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,
I am try to understand you query, but i am fail
can you please provide more information and Business Logic?
also share you full data base structure so that i can help you.
0