i need to design a query for Sqlite the original query was like this
FROM PhysicianActivity INNER JOIN
Activity ON PhysicianActivity.ActivityID = Activity.ID RIGHT OUTER JOIN
PhysicianFrequency ON PhysicianActivity.PhysicianID = PhysicianFrequency.PhysicianID AND Activity.LegalEntityID = PhysicianFrequency.LegalEntityID
knowing that sqlite doesn't support RIGHT OUTER JOIN so i am stuck with LEFT OUTER JOIN but i can't convert this query to LEFT OUTER JOIN
can anyone help please ?
Aucun commentaire:
Enregistrer un commentaire