-
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.
thanks!
arage
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|