>> WHERE Table1_ID = (6000000 + Table2_ID) wouldn't it be this... WHERE Table1_ID = (Table2_ID - 6000000)??
-----Original Message----- From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 7:23 PM To: CF-Talk Subject: OT: A little SQL help I want to filter the output of two tables with a "where" clause. Simple enough. Except that the values in the two table keys look like this: Table 1 Table 2 ID ID 10 60000010 12 60000012 25 60000025 So, how can I write this SQL? WHERE Table1_ID = (6000000 + Table2_ID) OR WHERE Table1_ID = 600000||Table2_ID Those don't work. Any suggestions? Dave ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
