mercredi 3 février 2016

convert RIGHT outer join to left outer join sqlite

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