Joining 3 tables in sql-server -


i have 3 tables in sql-server table table b table c.

how can join 3 tables expressed in image below?

enter image description here

more information needed give correct piece of code, image need left joins.

(id's have been presumed)

select * customers c left join items on c.iid = i.id left join sales s on c.sid = s.id 

Comments