Desktop·25,145 discussions

Outer Join in Access

Locked

I see that Access is mentioned and I have an Access question. Can you help?I set up an outer join comparing 2 tables in Access. I followed the MS Access Manual, though, this is my first experience using Access since I have only worked with IBM DB2 in the past. Where can I read more on how to setup Access for outer joins correctly? My test set is small and I know I have rows in one table but not in another and they are not being selected when I run the outer join select statement. PS. I was demoing Access and if this worked, I would have purchased a copy but my trial time expired. I was helping a friend. Thanks ahead of time!

Topic

Clarifications

In reply to Outer Join in Access

Clarifications

Here’s a good site I’ve used when looking for

In reply to Outer Join in Access

solutions to Access problems….they have a good tutorial & lots of examples….it should help you become familiar with Access.

http://www.functionx.com/access/index.htm

Thanks Darryl

In reply to Here’s a good site I’ve used when looking for

I will give it a try, will let you know if I figure it out. How is the sport fishing in your area. I have a boat, fish Lake Erie for some nice walleyes but always wanted to visit Nova Scotia some day.. Thanks again!

RE: Fishing

In reply to Thanks Darryl

The lakes are pretty good for trout up to about 15-16 inches…rivers & brooks a little smaller.
Atlantic Salmon so-so in some rivers but quite expensive for non-resident licenses.
A lot of Bass all along the Bay of Fundy (fish from shore).
Mackerel is plentiful all along the coast & you don’t have to go out too far so a small boat is fine.
Over in PEI & along the south shore of NS you can go deep sea fishing for Tuna, Swordfish, etc.

I don’t do much fishing….I just like to buy it fresh & eat it 🙂

Fishing

In reply to RE: Fishing

Thanks for the info. I will keep this for when I get to Nova Scotia some day. I will try the trout for sure.

Just switch to sql view

In reply to Outer Join in Access

and type the bugger in. It will be join syntax not =+.

Onec you’ve done that if you are really curious switch back to design view. The Gui is a bit unintuitive for those of us who just batter away with that old fashioned text type stuff.

LOL….yes…so true Tony….

In reply to Just switch to sql view

That’s just too funny ’cause I do exactly that at work when talking/explaining to co-workers….That’s usually what I do also….I just wanted to point out options…

First time I used the damn thing

In reply to LOL….yes…so true Tony….

I spent fifteen minutes trying to find distinct. Found View SQL View while trawling through menu options. That’ll do me fine. I write better SQL than it does anyway….

[Author]

Replies