+420 On Tue, Jun 21, 2011 at 2:45 PM, Michael Grant <[email protected]> wrote: > > Off topic, but the "Select *" made me shudder. > > > On Tue, Jun 21, 2011 at 2:25 PM, Jenny Gavin-Wear < > [email protected]> 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:345502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
