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 ------- the original question, corrected <sheepish-grin> ---- Given 3 tables: Table Operations(Op) Op_ID, Op_Name,... and Table TravelerHEADER(TravH) TravH_ID, TravName, Part_ID,... and Table TravelerDetail(TravD) TravD_ID, TravH_ID, Op_ID, TravOrder,... How can I retrieve the OP RecordSet associated with the subset of TravD records given a single TravH_ID ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
