help queries is not working

[ahmed-aljawad]

im doing a DB for the HR dep. i did all the requerd table and most of the queries but when im tring to do one from deferent table i can save it but after i run it it is showing me the attached massage. plz help

[TheShabz]

when you do an outer join, the rest of the joins coming from the the table the arrow is pointed towards must be outer joined as well. for example:

Table 1 ----> Table 2 ----- Table 3
will give you the error you received.

Table 1 ----> Table 2 <----- Table 3
will also give you an error.

Table 1----> Table 2 ----->Table 3
is correct.

[ahmed-aljawad]

than you i got it fixed

[TheShabz]

No problem. Please mark the thread "solved".