She didn't provide column names... On Tue, Jun 21, 2011 at 1:45 PM, Michael Grant <mgr...@modus.bz> wrote:
> > 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:345503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm