Sweet. Thanks James. That did the trick. On 3/12/07, James Holmes <[EMAIL PROTECTED]> wrote: > > 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) > > Bruce Sorge
"I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2773 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
