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
