queries -- outer join

L

loparque

Hi, I want to know if is possible make an OUTER JOIN using
more than two tables, because when I try appear a message that
says is wrong
thanks in advance

loparqu
 
D

Debra Dalgleish

If you have an outer join in an MS Query (Data>Import External Data),
you can only use two tables in the query.
 
L

loparque

thanks all, one more question

I see the next forums :

1 - Excel Miscellaneous
2 - Excel General
3 - Excel Programming
4 - Excel Worksheet Functions
5 - Excel Charting
6 - Excel - New Users


where should I post my thread ?
where is MS Access forum that Frank says ?
sorry for my ignorance

Loparqu
 
D

Dave Peterson

You're accessing the Microsoft Public newsgroups from excelforum. I don't know
if there is an access equivalent, but you could connect directly to the
microsoft servers:

(I don't know any Access newsgroups, but there are lots. You should be able to
subscribe to one that looks nice once you connect directly.)

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers
news://msnews.microsoft.com/microsoft.public.excel.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsoft.public.word.docmanagement
news://msnews.microsoft.com/microsoft.public.word.word97vba
news://msnews.microsoft.com/microsoft.public.word.newusers
news://msnews.microsoft.com/microsoft.public.word.pagelayout
news://msnews.microsoft.com/microsoft.public.word.vba.addins
news://msnews.microsoft.com/microsoft.public.word.vba.beginners
news://msnews.microsoft.com/microsoft.public.word.vba.customization
news://msnews.microsoft.com/microsoft.public.word.vba.general
news://msnews.microsoft.com/microsoft.public.word.vba.userforms
news://msnews.microsoft.com/microsoft.public.word.word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
 
O

onedaywhen

Debra Dalgleish said:
If you have an outer join in an MS Query (Data>Import External Data),
you can only use two tables in the query.
Click to expand...

Incorrect. The SQL gets passed to the DBMS so if the DBMS can handle
multiple outer joins then so can MS Query. I posted some examples,
using multiple nested/derived table outer joins using pubs (SQL
Server) and northwind (MS Access) respectively and the queries work in
MS Query, in the following thread:

http://groups.google.com/groups?thr...d0b7.0404190353.11f1a988%40posting.google.com

--
 
D

Debra Dalgleish

Thanks for the info. Creating the query in Access, and linking to that,
would be much easier though, unless the OP is familiar with SQL
 
Top