Re: Why isn't this left join query working

You're correct that I edited the SQL (sorry - I had a brainwave that
qry would be confusing) but there was no where clause.

SELECT qryAUM2.Geography, qryAUM2.Product, qryAUM2.AssetClass,
qryAUM_PropSplit3.Asset, [AUM_Value]*[Perc] AS AUM
FROM qryAUM2 LEFT JOIN qryAUM_PropSplit3 ON (qryAUM2.AssetClass =
qryAUM_PropSplit3.OrigAsset) AND (qryAUM2.Product =
qryAUM_PropSplit3.Product) AND (qryAUM2.Geography =
qryAUM_PropSplit3.Geog);

.

Relevant Pages

  • Re: Why isnt this left join query working
    ... qry would be confusing) but there was no where clause. ... If I put the same query into SAS but edit the FROM clause it works: ... FROM qryAUM2 LEFT JOIN qryAUM_PropSplit3 ...
    (microsoft.public.access.queries)
  • Re: Undead Persistence, wording of optional press
    ... if that clause doesn't turn ... Undead Persistence into superior Conquer the Beast, ... they would have had to have seen it on another card. ... As I said, read by itself, the card is just not that confusing. ...
    (rec.games.trading-cards.jyhad)
  • Re: Undead Persistence, wording of optional press
    ... confused for that clause. ... Undead Persistence into superior Conquer the Beast, ... that Meat Hook has been fixed to grant a press only once per combat. ... As I said, read by itself, the card is just not that confusing. ...
    (rec.games.trading-cards.jyhad)
  • Re: [python] using try: finally: except
    ... >> it still confusing even though the order of execution changed ... a 'finally' clause had to be the last clause in a ... The finally clause is to finalise code in the try block. ...
    (comp.lang.python)
  • Re: Undead Persistence, wording of optional press
    ... if that clause doesn't turn ... Undead Persistence into superior Conquer the Beast, ... just isn't that confusing. ...
    (rec.games.trading-cards.jyhad)