Outer Joins in SQL Server

unknown

I am in the process of upgrading our Visual Databae from SQL Base 9 to SQL Server. We have a test conversion of our database up and running, and have found that any of the QRP extended queries in our system using joins no longer work. They return and error like:

Incorrect syntax near ','.


Most of these queries used Inner Joins, and I was able to rewrite these using new syntax and WHERE conditionals, but I have two queries that use Outer Joins that I can not figure out how to write for our new database. I tried the *= suggested in another discussion thread, but that returned the following error:

The query uses non-ANSI outer join operators ("*=" or "=*").

I appreciate any help.

VID035_Colorization_Color Options for Fields.zip

unknown

Hi,

Try this kind of syntax writing.

You can use rigt, left, inner when is convinient

SELECT *

FROM
R5EVENTS E
INNER JOIN R5ORGANIZATION ORG ON ORG.ORG_CODE = E.EVT_ORG
INNER JOIN R5OBJECTS O ON O.OBJ_CODE = E.EVT_OBJECT AND O.OBJ_OBTYPE = 'S'
LEFT JOIN R5STRUCTURES S1 ON S1.STC_CHILD = O.OBJ_CODE
LEFT JOIN R5OBJECTS PARENT ON PARENT.OBJ_CODE = S1.STC_PARENT
LEFT JOIN R5STRUCTURES S2 ON S2.STC_CHILD = PARENT.OBJ_CODE
LEFT JOIN R5OBJECTS GRANDPARENT ON GRANDPARENT.OBJ_CODE = S2.STC_PARENT
LEFT JOIN R5AGREEMENTS A ON A.AGR_CODE = E.EVT_AGREEMENT
LEFT JOIN R5UDVBOOSUM1 H ON H.wol_event = E.EVT_CODE
WHERE
E.EVT_CREATED >= '2008-01-12'