<CFQUERY name="get_tasks" datasource=taskomatic>
SELECT t .taskID,
t .taskname,
t .status,
t .project,
p .projectsID,
p .projectname,
p .client ,
c.clientName
FROM tasks t JOIN projects p
ON t.project = p.projectsID
JOIN clients c
ON p.client = c.clientID
</CFQUERY>
<CFOUTPUT query="get_tasks">
#taskname# #status# #projectname#
#clien Name t#
</CFOUTPUT>
Note a couple of things - using a 1 letter alias makes your column
names stand out a bit better. The join syntax is clearer for my
money because it describes the actual task at hand - and you
can control the "type" of join with join keywords without additional
"where" clauses.
-Mk
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
