Hi,
I have the DB diagram as attached here.I would like to create a single query as per joins mentioned in the diagram.I am not sure if i need:
inner joins or left outer or right outer
Can you pls guide on how to write out a single query joining tables as per diagram.
I have created some dummy table names and keys for security reasons.Pls bear with it.
Note:
Lines is main table.
