Off topic, but the "Select *" made me shudder.
On Tue, Jun 21, 2011 at 2:25 PM, Jenny Gavin-Wear < jenn...@fasttrackonline.co.uk> wrote: > > Looks like I went with the vote, lol > > Many thanks for all replies, and fast too :) > > Some payments from Paypal transactions, some manually entered on profiles. > Legacy code :/ > > Jenny > > select * from tbl_members > where > (datepart(m,paid) = #session.month# and datepart(yyyy,paid) = > #session.year# > AND > memberID not in > (select memberID from tbl_paypal > where datepart(m, payment_date) = #session.month# and > datepart(yyyy,payment_date) = #session.year# > )) > order by paid > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm