Putting a condition WHERE tblTaskComplete.Proc_ID = 72 eliminates
all the rows you outer joined. You need something 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 AND tblTaskComplete.Proc_ID = 72)
On 3/13/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> 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:2772
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
