I want to do an outer join on two tables which both have a field containing an email address.
SELECT * from user LEFT JOIN GIFTCODES WHERE USER.email=GIFTCODES.userE
This fails to compile. The where clause is rejected.
I am trying to implement an example at this URL:
The example looks like this:
SELECT * T1 LEFT JOIN T2 ON P1(T1,T2)
WHERE P(T1,T2) AND R(T2)
I do not understand how to modify "P1". If I type it in literally I get the error message "Survey.P Does not exist".
Can anyone help?