A join should work:
SELECT t.TimesID, t.Times, c.ClientID, c.AppTimeID, c.Name
FROM TimesTable t
LEFT JOIN ClientsTable c
ON t.Times = c.AppTimeID
ORDER BY t.Times
--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com
"JohnGree" <webforumsuser@macromedia.com> wrote in
message
news:ehaeug$57l$1@forums.macromedia.com...
> Hi i have 2 table
>
> **TimesTable**
> TimesID
> Times
>
>
> **ClientsTable**
> ClientID
> AppTimeID
> Name
>
> what i want to do is show all the "Times.Times" in a
list which i have
> done
> with a cfoutput query
>
> then if "ClientsTable.AppTimeID" matches the
"Times.Times" show it next to
> the
> time in the output
>
> ie
> 08:00 John
> 09:00
> 10:00 Paul
> 11:00
>
> do i need to join the query or use a cfif tag?
>