mardi 5 mai 2015

2 Many to Many relationship - extract data with join

Please check the schema in the link below.

http://ift.tt/1JpkZl1

I want to select all properties and also the agent and the owner of each property. The problem is that both agent's and owner's details comes from the same table and there is a conflict.

What solution should i follow?

Note: Unfortunately I cannot change the db schema.

Aucun commentaire:

Enregistrer un commentaire