Re: [MS_AccessPros] sql queries

 

Phucon-

You failed to include the previous discussion, so I have no clue what you're talking about.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Nov 5, 2015, at 3:40 PM, saigonf7q5@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning Mr. Viescas

In my "2-step" method, which is joining 2 separated queries (the MostRcent and the query that contains records right before the MostRecent), since 1 query contains more records than the other, I used the outer join to get all the records.

In this "1-step" query, since both tables are actually the same, how do I construct the join to get an outer join result?

Phucon

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___