Re: converting from oracle sql
This is what I finally came up with:
select distinct(school.user_id), school.value as school, year.value as year
from jos_community_fields_values as school inner join jos_community_fields_values year on
school.user_id = year.user_id
and school.value = 'Marist Brothers‘‘ High School'
and year.value = '1986'
Subject
Views
Written By
Posted
5073
December 10, 2008 12:11PM
Re: converting from oracle sql
2773
December 10, 2008 02:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.