Hi,
Could anybody convert this SQL syntax to Oracle format
Thanks
SELECT "COMPANY"."NAME" CompanyName, "EMPLOYEE"."LAST", "EMPLOYEE"."FIRST",
"PROJECT"."NAME" ProjectName, "PREFS"."ITEEMP", "TASK"."NAME" TaskName, "TRANS"."TOTAL",
"EMPLOYEE"."ID" EmpID, "PROJECT"."ID" ProID, "TASK"."ID" TaskID, "TRANS"."EMPRATE",
"TRANS"."PRORATE", "TRANS"."OTRATE", "TRANS"."EMPCOST", "PREFS"."ITEPRO",
"TRANS"."OTCOST", "TRANS"."DATE", "CLIENT"."ACR", "GROUP"."NAME" GroupName
FROM CLIENT INNER JOIN TRANS TRANS INNER JOIN TASK TASK ON TRANS.TASK = TASK.ID
INNER JOIN PROJECT PROJECT ON TRANS.PROJECT = PROJECT.ID
INNER JOIN EMPLOYEE EMPLOYEE ON TRANS.EMPLOYEE = EMPLOYEE.ID
INNER JOIN [GROUP] [GROUP] ON EMPLOYEE. [GROUP] = [GROUP].ID ON CLIENT.ID = PROJECT.CLIENT
CROSS JOIN PREFS
CROSS JOIN COMPANY
WHERE (TRANS.APPROVED = 'T') AND (TRANS.ERROR = 'F')
Could anybody convert this SQL syntax to Oracle format
Thanks
SELECT "COMPANY"."NAME" CompanyName, "EMPLOYEE"."LAST", "EMPLOYEE"."FIRST",
"PROJECT"."NAME" ProjectName, "PREFS"."ITEEMP", "TASK"."NAME" TaskName, "TRANS"."TOTAL",
"EMPLOYEE"."ID" EmpID, "PROJECT"."ID" ProID, "TASK"."ID" TaskID, "TRANS"."EMPRATE",
"TRANS"."PRORATE", "TRANS"."OTRATE", "TRANS"."EMPCOST", "PREFS"."ITEPRO",
"TRANS"."OTCOST", "TRANS"."DATE", "CLIENT"."ACR", "GROUP"."NAME" GroupName
FROM CLIENT INNER JOIN TRANS TRANS INNER JOIN TASK TASK ON TRANS.TASK = TASK.ID
INNER JOIN PROJECT PROJECT ON TRANS.PROJECT = PROJECT.ID
INNER JOIN EMPLOYEE EMPLOYEE ON TRANS.EMPLOYEE = EMPLOYEE.ID
INNER JOIN [GROUP] [GROUP] ON EMPLOYEE. [GROUP] = [GROUP].ID ON CLIENT.ID = PROJECT.CLIENT
CROSS JOIN PREFS
CROSS JOIN COMPANY
WHERE (TRANS.APPROVED = 'T') AND (TRANS.ERROR = 'F')