Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- pr.id personid,
- pr.forenames,
- pr.surname,
- pr.membershipnumber,
- pr.renewaldue,
- pr.dateofbirth,
- py.id paymentid,
- CAST(py.creationdatetime AS DATE) [DATE Paid],
- py.creationuserid [Taken BY],
- py.paymentamount,
- CAST(c.bookedoutdatetime AS DATE) [DATE Card Sent]
- FROM
- dbo.person pr
- JOIN dbo.payment py ON
- py.personid = pr.id
- AND py.creationdatetime > '01 JAN 2022'
- AND py.paymentmethod = 'CARD'
- AND py.returncode = 1
- LEFT JOIN dbo.card c ON
- c.personid = pr.id
- AND c.bookedoutdatetime > py.creationdatetime
- AND c.hotlisteddatetime IS NULL
Advertisement
Add Comment
Please, Sign In to add comment