I am querying from two tables. The query looks like this:
SELECT tblTaskComplete.Proc_ID, tblTaskComplete.Task_ID,
tblTaskComplete.DateCompleted, tblTaskComplete.Status_ID,
tblTasks.DaysOut, tblTasks.Alert, tblTasks.Task,
tblTasks.councilTask, tblTasks.TaskID
FROM tblTaskComplete RIGHT OUTER JOIN tblTasks ON tblTaskComplete.Task_ID=
tblTasks.TaskID
WHERE tblTaskComplete.Proc_ID = 72
No matter what type of join I jse, what I get are three records (there are
three records in the tblTackComplete table. What I want is everything from
the tblTasks table and then the areas where the task_ID match in both
tables, I want those fields filled out with the data from tblTaskComplete. I
know this is simple but I am having massive brain farts today. Stupid flu is
killing me.
Thanks,
--
Bruce Sorge
"I'm a mawg: half man, half dog. I'm my own best friend!"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2771
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
