I don't know what DBMS you are using, but should you have quotes around all of the values in your IN clause, like so: AND table_1.table_id IN ('value1','value2','value3')
> -----Original Message----- > From: Jillian Koskie [mailto:[EMAIL PROTECTED] > Sent: Friday, October 28, 2005 4:12 PM > To: CF-Talk > Subject: OT - Complex SQL > > Okay, I think it's because it is Friday at 4... can somebody help me > out? > > SELECT table_1.expiry_date, > table_3.expiry_date > FROM table_3 > JOIN table_2 ON table_2.table2_key = table_3.tablel2_key > JOIN table_1 ON table_1.table1_key = table_2.table1_key > WHERE table_1.expiry_date = 'Dec 31, 2005' > AND table_3.expiry_date = 'Dec 31, 2005' > AND table_1.table_id IN ('value1,value2,value3') > > This isn't returning results, and it should... where is my syntax > incorrect? [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222626 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54