It's late, and I'm being dumb, so can anyone help ? I know that select customer.custcode, bookings.cust from customer left join bookings on customer.custcode=bookings.cust where bookings.cust is null;
will show me all customers with no corresponding entry in bookings table. But I want to know those customers with no bookings in last few weeks : I thought maybe select customer.custcode, bookings.cust from customer left join bookings on customer.custcode=bookings.cust where bookings.stdt > '2002-02-16' and bookings.cust is null but that aint right. Help ? Please ? David bot-bait sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
