View Single Post
  #2 (permalink)  
Old November 29th, 2009, 02:18 AM
iamrakesh22 iamrakesh22 is offline
Friend of Wrox
 
Join Date: Mar 2007
Location: Hyderabad, A.P., India.
Posts: 373
Thanks: 0
Thanked 1 Time in 1 Post
Default

You can try by joining 'customers' table with a temporary table instead of directly joining 'cust_packages'.
you query might look
'SELECT ... FROM customers AS c, (SELECT .. FROM cust_packages WHERE cpack_canceldate IS NOT NULL) cc
WHERE c.cust_custnr=cc.cpack_usernr'

What do you think!
__________________
- Rakesh
http://iam-rakesh.blogspot.com
Reply With Quote