Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tripathibhupesh
Starting Member
10 Posts |
 Posted - 2006-04-24 : 10:55:25
|
| hi all i have two tables accounts and payments related with an accountid accounts(accid,balance...)payments(accid,payment,timestamp..)what i am trying to do is report all the accounts whose balance is -vewith days since last paymentsi tried achieving this by a join query now my prob is i want to even display records that are not present in payments ie no payments are made in that account n display no payments or something else eg accountid balance lastpayments1 -150 3 days 2 -200 4 days3 -90 No Paymentsplease help thanks |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-24 : 10:59:05
|
| I think left join payments & use of Case - When Payment is Null - Then ... will work for uSrinika |
 |
|
|
|
|
|
help with a query