On 12/22/01, Gonzo Rock penned: >You are SOOO Right... It did NOT put it in my example... BUT... It >is in my table design. (I hate when I screw up in email like that! >It really complicates this process.) > >My delima is given a TravH_ID, create a list of all the OP Records >related to the related set of TravD records via the travd.op_id field > >I have created something like this but it is returning an Op.OP_ID >for ALL records in the traveled file... (it's not respecting the >travd.travh_id = 1 restriction) > >SELECT op.op_id, op.released >FROM op, travD, travH >WHERE travD.travH_id = 1 AND op.op_id = travD.op_id
Looks like you're missing a Join. AND travH.travH_ID = travD.travH_ID -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
