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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists