By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,140 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

outer join - second post

P: n/a
Hello,
I want to do left outer join in access 2002.
1) Isn't any way to do without the words "left outer join", like :
table1.column1 = table2.column2 (+)
that was the simple Oracle syntax, and is there any access syntax.

2) I want to do nested outer join - how ?
Need an example, please.

I have tried something like :
---------------------------------

Select l.FORM_NAME,
f.FORM_DESCR
from table_form_link l
left join maa_form f on l.form_name = f.form_name
left join menu_prog p on f.form_name = p.entry_prog
where l.table_name = 'ACNTS'
order by l.FORM_NAME

but the above doesn't work.
Why ?
Thanks :)

May 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> but the above doesn't work.

Because Access/Jet requires braces () around the clauses.
and uses the keyword "as" for table aliases.

Select l.FORM_NAME,
f.FORM_DESCR
from (table_form_link AS l
left join maa_form AS f on l.form_name = f.form_name)
left join menu_prog AS p on f.form_name = p.entry_prog
where l.table_name = 'ACNTS'
order by l.FORM_NAME

The nesting of the joins is enforced by the brackets.
That is as close as I can get by eye. If you draw the
query in the Query By Example grid, Access will write
the SQL for you: you can switch to the SQL view to see
valid JET SQL.

(david)
PS: Oracle also supports ANSI join syntax.
"Eitan M" <no_spam_please@nospam_please.com> wrote in message
news:e5**********@news2.netvision.net.il...
Hello,
I want to do left outer join in access 2002.
1) Isn't any way to do without the words "left outer join", like :
table1.column1 = table2.column2 (+)
that was the simple Oracle syntax, and is there any access syntax.

2) I want to do nested outer join - how ?
Need an example, please.

I have tried something like :
---------------------------------

Select l.FORM_NAME,
f.FORM_DESCR
from table_form_link l
left join maa_form f on l.form_name = f.form_name
left join menu_prog p on f.form_name = p.entry_prog
where l.table_name = 'ACNTS'
order by l.FORM_NAME

but the above doesn't work.
Why ?
Thanks :)

May 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.