Outer join

From: <art_at_unsu.com>
Date: Wed, 17 Sep 2008 11:33:07 -0700 (PDT)
Message-ID: <f11961ed-579a-4a63-b20e-f2f39782696b@8g2000hse.googlegroups.com>


This is simple, at least for others. What's wrong with this? It only returns the rows in the fund_daily_prices table.....not all the ones in fund_rank which have no matching in fund_daily_prices .

SELECT fund_rank.idnum
FROM fund_rank LEFT OUTER JOIN fund_daily_prices ON fund_rank.idnum = fund_daily_prices.idnum
WHERE seq_no > 0
  AND seq_no <= 50 ORDER BY seq_no; Received on Wed Sep 17 2008 - 13:33:07 CDT

Original text of this message