Same qry structure, different results

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JR (anonymous_at_discussions.microsoft.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 04:07:25 -0700

Please, does anyone have any insights as to why the first
of the two queries below functions as desired while the
second does not?

The following query does what I want it to do, which is
provide 0 (zero) fills whenever there is an "SRC" in
tblAllSRCs.SRC but not in qryTotalbySRC.

SELECT tblAllSRCs.SRC, AllSRCs.Title, AllSRCs.Strength,
qryTotalSRC.[SumOfSumOfST LBS]
FROM tblAllSRCs LEFT JOIN qryTotalbySRC ON
tblAllSRCs.SRC = qryTotalSRC.SRC;

The following query does NOT do what I want it to do.
It omits the SRC from tblAllSRCs.SRC when there is no
corresponding SRC in qryIXSRCList.

SELECT tblAllSRCs.SRC, AllSRCs.Title, AllSRCs.Strength,
[qryIXSRCList].COorST
FROM tblAllSRCs LEFT JOIN [qryIXSRCList] ON tblAllSRCs.SRC
= [qryIXSRCList].SRC;

Thanks.

Relevant Pages

  • Re: Same qry structure, different results
    ... > FROM tblAllSRCs LEFT JOIN qryTotalbySRC ON ... > The following query does NOT do what I want it to do. ... > corresponding SRC in qryIXSRCList. ...
    (microsoft.public.access.queries)
  • same qry using different component = different results?
    ... qryTotal_V_bySRC.[SumOfSumOfAT LBS], ... The following query does NOT do what I want it to do. ... It omits the SRC from tblAllSRCs.SRC when there is no ... FROM tblAllSRCs LEFT JOIN [qry IX --> 06) Final SRC List ...
    (microsoft.public.access.queries)
  • Re: Comparing 2 different databases [NEWBIE]
    ... > To write queries across multiple databases, you simply need to fully qualify ... > AS IsSame ... > FROM DB1.dbo.Table1 AS src ... understanding what you did up there with your query I'm scanning my book ...
    (microsoft.public.sqlserver.programming)
  • Re: XYZ AS in union query gives ORA-00918
    ... I've created an union query like this: ... select 'DB' AS SRC, ... fields the query is corecctly processed. ... The sense of the query is to show changed data before applying the ...
    (comp.databases.oracle.misc)
  • LinkButton Events
    ... I have 2 datagrids, lets call them src and dest. ... I run a query and databind ...
    (microsoft.public.dotnet.framework.aspnet)