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

Outer Joins

P: 35
I have 2 tables, address and address_details.

If there is a value in address then there may or may not be a value in address_details, but I would like to display both regardless.

I don't want to use the WHERE clause to meet the join conditions because that would only bring back results if there are records in both tables. I don't think it's an inner join that I want, but for the life of me I can't remember the syntax for an outer join for SQL.

Can someone please point me in the right direction for the syntax for an outer join in Access SQL, thanks. I'm working on 2000
Sep 7 '07 #1
Share this Question
Share on Google+
1 Reply


P: 35
I've done it, thanks anyway
Sep 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.