change it accordingly:
<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 INNER JOIN
projects P ON T.project = P.projectsID INNER JOIN
clients C ON C.clientID = P.client
</CFQUERY>
g'luck,
-jc
Chris Kavanagh wrote:
> Dear list,
>
> As the witching hour approaches and my first deadline draws near,
> expect my stress levels to climb and my emails to get less and less
> graceful. For now, I feel remarkably composed, although I don't
> suppose I'll be getting to bed anytime soon.
>
> Now: this query fetches some data from two tables.
>
> <CFQUERY name="get_tasks" datasource=taskomatic>
> SELECT
> tasks.taskID,
> tasks.taskname,
> tasks.status,
> tasks.project,
> projects.projectsID,
> projects.projectname,
> projects.client
> FROM tasks, projects
> WHERE tasks.project=projects.projectsID
> </CFQUERY>
>
> Further down I have a table that looks something like this:
>
> <CFOUTPUT query="get_tasks">
> #task.taskname# #task.status# #projects.projectname#
> #projects.client#
> </CFOUTPUT>
>
> The trouble is that the field project.client just returns the primary
> key from another table (clients). I'd like it to display the field
> clients.clientname.
>
> I appreciate that this an extremely low hurdle to fall at but I've been
> frying my brain with this stuff for days and I'm finding it hard to
> think straight...
>
> Kind regards,
> CK.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
