I got it: Table2_ID = (6000000 + Table1_ID)
Thanks, Dave ----- Original Message ----- From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 10:26 PM Subject: RE: A little SQL help > >> 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 > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
