Well, I didn't see that association in your example. This is your example...
> Table TravelerHEADER(TravH) > TravH_ID, TravName, Part_ID,... > > and > > Table TravelerDetail(TravD) > TravD_ID, Op_ID, TravOrder,... I don't see TravH_ID in your TravD table. Sorry for the mix up. Good luck! Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 ----- Original Message ----- From: Gonzo Rock To: CF-Talk Sent: Friday, December 21, 2001 11:57 AM Subject: Re: SQL Question Hi Michael, Well there is the association between the header and it's details, (a one to many) with the travh_id field in the travd file... I'm not sure I understand why it is REQUIRED... in fact I was thinking it was not recommended... but then... again I'm pretty new... thanks, GR At 01:43 PM 12/20/01 -0600, you wrote: >It looks like you need to add TravH_ID to the TravD table. That way you >have the association between the header and its details: > >TravD_ID TravH_ID >1 1 >2 1 >3 1 > >etc. > >Then you can get it all with TravH_ID to include OP_ID > >HTH > >Michael Corrigan >Programmer >Endora Digital Solutions >www.endoradigital.com >630/942-5211 x-134 > ----- Original Message ----- > From: Gonzo Rock > To: CF-Talk > Sent: Thursday, December 20, 2001 12:52 PM > Subject: SQL Question > > > 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, Op_ID, TravOrder,... > > How can I retrieve the OP RecordSet > associated with the subset of TravD records > given a single TravH_ID > > IE: For every singular TravH header record there are multiple TravD >detail records, each of which is related to a singular OP record. I want >the OP RecordSet represented by the travD RecordSet. > > I've been trying to do this in a single query statement... do I sound >way new ;) ... I am. > > thanks, > Gonzo > > ______________________________________________________________________ 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
