Re: Right join in mysql and sqlserver

[dragone]

The query (in sql server) is

select distinct …..
from
((( C INNER JOIN D ON C.c1=D.d1) RIGHT JOIN B ON C.c2 =B.b1 ) RIGHT JOIN A ON B.b2=A.a1)
where …;


I have tree main table A,B,C
Every table has a key that corresponds to a key in another table(a foreign key)
For example A.a1=B.b2.

The problem is that if there isn't a value in C that corresponds to a value in B the result is null and the query doesn't work well.
I would like that the query returns the lines even if there is no corrispondence in B and C
Thanks
DD