is this not a valid FROM statement in sql?

[arage]

is this not a valid FROM statement in sql?

FROM Director, tblMonth LEFT JOIN newQuery ON (tblMonth.Type = newQuery.PromotionType) AND (tblMonth.Month=newQuery.tempMonth) AND (Director LEFT JOIN newQuery ON Director.Code=newQuery.regionalDirectorCode)

i get an error on:

(tblMonth.Month=newQuery.tempMonth)

about it having invalid syntax but it worked before when i used everything but the last AND condition.

[pando]

i have never used LEFT JOIN syntax in Oracle, actually I didnt know it works!

[OCPIP]

is this not a valid FROM statement in sql?

R u talking about sql in Oracle .

Seen these kind if codes in VB. Never seen LEFT JOIN in Oracle.


OCP IP.

[dknight]

What should left join accomplish?

Thanks in advance.

[balajiyes]

HI u cannot use these type of jin in Oracle
these types of joins r in MS SQL SERVER & SQL ANYWHERE