Hey, how do i make a query object between two datasources and with the given conditions in the sql statement below, would greatly appreciate any help.
SELECT * FROM
Table1
LEFT JOIN Table2 ON Table1.RelatedField = Table2.RelatedField
WHERE Table1.Field = ‘someValue’ OR (Table1.Field = ‘someValue’ AND Table2.Field= ‘someValue’)
