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