Apex Code Development You need to sign in to do that
Don't have an account?
nickname142857 Query question (full outer join)
I have a parent object which has a period field, and a child object that also has a period field. And I want to get all rows that either parent.period = 'Jan' or child.period = 'Jan' (with just one query).
I cannot do something like
select ..., (select ..., from child where period = 'Jan') from parent where period = 'Jan'
because it will only return records for which parent.period = 'Jan'.
Anyone has any thoughts, suggestions?
did u try something like this:
List <List<SObject>> searchList = [ FIND :'Jan' IN period FIELDS RETURNING parent,child)];