Left Inner Join in Universe

[Former Member]

I have the following SQL statement:

SELECT *

FROM A INNER JOIN B ON A.ID = B.UNIQUEID

LEFT JOIN C ON A.ID = C.CID

I create an universe but I'm unable to join the tables due I don't have any idea join the tables using the LEFT JOIN. The left join is necessary to join these 3 tables.

[Former Member]

Thank you for the support.

[Former Member]

Hi Miquel,

In the join dialog box, there is an outer check box under each tables field listing. You can select these and it will perform the outer join.

The syntax is the old format, rather than the LEFT OUTER JOIN format.

Regards

Alan