converting from oracle sql
I have a table with structure/values as follows:
1, 60, 20, '1986'
2, 60, 21, 'Marist Brothers' High School'
3, 61, 20, '1986'
4, 61, 21, 'Marist Brothers' High School'
I need to create a sql that shows which users shared the same year and school.
The following sql for oracle works:
(SELECT nvl(n.user_id,y.user_id) user_id,n.value school, y.value year
WHERE field_id = 20
FULL OUTER JOIN
WHERE field_id = 21
) n ON y.user_id = n.user_id
WHERE t.year = ‘1986‘
and t.school = ‘Marist Brothers‘‘ High School‘
I have been trying to convert this to MySQL but with no luck so far. I found out that there is no OUTER JOIN feature in MySQL. What else can I do?
Edited 2 time(s). Last edit at 12/10/2008 12:14PM by Donovan Makund.