Page 1 of 1
R&R v10.0.012 Sql-User
Posted: Fri Mar 28, 2003 2:35 pm
by Bill_Henderson
Hello all,__New to version 10. I am trying to use a SQL command that uses FULL OUTER Join, any reason why this fails ?
=> RE: R&R v10.0.012 Sql-User
Posted: Fri Mar 28, 2003 3:13 pm
by kfleming
Either the driver or R&R^s driver interface does not like your syntax.__What driver are you using and what is the exact SELECT that you are entering?____Kathleen__R&R Support
==> RE: R&R v10.0.012 Sql-User
Posted: Sun Mar 30, 2003 9:23 am
by Bill_Henderson
The driver and code below is what I^m using:____Microsoft SQL Server ODBC Driver Version 03.81.9031______SELECT _ISNULL(et.Empl_id, a.Empl_id) AS Empl_id, ____ISNULL(et.Task_id, a.Task_id) AS Task_id, ____ISNULL(et.Actual_Time, 0) + SUM(ISNULL(a.Actual_Time, 0)) AS Actual_Hours, ____ISNULL(et.Adjust_Time, 0) + SUM(ISNULL(a.Adjust_Time, 0)) AS Adjust_Hours, ____ISNULL(et.RecordDate, a.CurrentDate) AS RDate, ____ISNULL(et.Comments, a.Comments) AS Comments, ____ISNULL(et.Entry_Status, ^p^) AS Entry_Status____FROM _EmpTime_Info et, FULL OUTER JOIN Adjustment a, ON et.Empl_id = a.Empl_id __AND __et.Task_id = a.Task_id __AND __a.CurrentDate = et.RecordDate____GROUP BY _ISNULL(et.Empl_id, a.Empl_id), ____ISNULL(et.Task_id, a.Task_id), ____et.Actual_Time, ____et.Adjust_Time, ____ISNULL(et.RecordDate, a.CurrentDate), __ ISNULL(et.Comments, a.Comments), ____et.Entry_Status