RIGHT OUTER JOIN

Hi,

i need an equivalent code to

RIGHT OUTER JOIN

i do not want to use that.

ex,

SELECT dbo.Test1.a, dbo.Test1.b, dbo.Test1.c, dbo.Test.t
FROM dbo.Test RIGHT OUTER JOIN
dbo.Test1 ON dbo.Test.a = dbo.Test1.a

thanks

Will you accept the left join equivalent? Why are you avoiding the RIGHT JOIN?|||

i ran the query in sql2005 thats fine

in access it wont.

|||Well, do you even need to join to the TEST table? Your query doesn't include any data from the TEST table.|||

Hi,

What version of access are you using? Just to see what syntax is supported.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

table a table b

a b c a d

1 10 x3 1 9

2 20 x2 2 8

3 30 x1 5 7

i need to get this without a join:

a b c d

1 10 x3 9

2 20 x2 8

3 30 x1 null

5 null null 7

I have conditions that i should not use right join, i know it is some access issue, i do not know versions.

so basically i write most codes without using joins, though i know ...

thanks,