What am I missing in outer join query

From: Sunny (sunny_1178_at_hotmail.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 12:51:51 -0500

I am having problem with outer join in query. I am sure I am missing
something and I am sure someone will point me the right direction.

I have 2 tables

AreaOffice
Purchases

I want all the records from Areaoffice and related purchases from Purchases
table.
AreaOffice:
AOId AOName
1 AreaI
2 AreaII
3 AreaIII

Purchases:
AOId Date Amount
1 7/1/04 100
1 7/2/04 200
3 7/1/04 300

What I want is
AOId AOName Date Amount
1 AreaI 7/1/04 100
1 AreaI 7/2/04 200
2 AreaII
3 AreaIII 7/1/04 300

But I dont get AreaII record on final result. Here is my query:

SELECT AreaOffice.AoId, AreaOffice.AOName, Purchases.Date, Purchases.Amount
;
from Areaoffice LEFT OUTER JOIN purchases on purchases.aoid =
areaoffice.aoid ;
order by ao_id

Why am I not getting expected records?

Thanks.

Relevant Pages

  • What am I missing in outer join query
    ... I am having problem with outer join in query. ... I want all the records from Areaoffice and related purchases from Purchases ... AOId AOName Date Amount ...
    (microsoft.public.fox.vfp.queries-sql)
  • What am I missing in outer join query
    ... I am having problem with outer join in query. ... I want all the records from Areaoffice and related purchases from Purchases ... AOId AOName Date Amount ...
    (microsoft.public.fox.helpwanted)
  • What am I missing in outer join query
    ... I am having problem with outer join in query. ... I want all the records from Areaoffice and related purchases from Purchases ... AOId AOName Date Amount ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Date based query problem
    ... Balance" query (calculates the beginning balance based on all sales & ... purchases up to the beginning date), ...
    (microsoft.public.access.reports)
  • Re: Subreport within a Report
    ... Statement" which comprises of a main report name "Purchases" and a subreport ... Likewise I have also created a query for subreport with the ... I have set the Purchases Query and Sales Query at the Record Source of the ...
    (microsoft.public.access.reports)