on 2009 Jan 08 8:08 PM
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.
Thank you for the support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.