select [company info] from company where company_id in (Select company_id
from employee where type='REP')
-----Original Message-----
From: kaigler [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 4:37 PM
To: CF-Server
Subject: Re: query help
I meant to say I need the company record (it holds the info I need) if and
only if there is an associated employee record that is considered a REP
record. I am going to join the table to itself and see if that will work.
thanks,
kaigler
At 04:24 PM 8/13/2001 -0400, you wrote:
>In a message dated 8/13/01 4:18:25 PM Eastern Daylight Time,
>[EMAIL PROTECTED] writes:
>
>
> > I have one table.....
> >
> > It includes employees and companies
> >
> > I need to find all of the companies that have an employee record where
> the
> > employee record is a REP type record.
> >
> > I assume this is where cold fusion 5's query a query come in handy. I
am
> > still running 4.5.2 (but I have been running 5 on my laptop while
> > developing using it kind of as a test). Anyone know how I can do this
> with
> > sql or am I SOL?
> >
> > kaigler
> >
>
>Appears to be a single query to me? I'm sure I'm missing something but:
>
>SELECT [company] FROM [table] WHERE [type]='REP'
>
>Cheers,
>Bill
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
