Re: ANSI joins not working...

From: Peter <pmwood_at_hotmail.com>
Date: 15 Jun 2005 01:02:14 -0700
Message-ID: <1118819398.250566.322680@o13g2000cwo.googlegroups.com>

Thanks everyone for the effort put into this. David Portas' response,

select p.PORTFOLIO_CODE, h.HOLDING_NUMBER_SHARES from PORTFOLIO_MASTER p left outer join PORTFOLIO_HOLDINGS h on p.PORTFOLIO_CODE = h.PORTFOLIO_CODE and h.INSTRUMENT_CODE = 'AFI'

does what I was looking for, and I can see why, though I thought part of the point of the ANSI syntax was to separate join conditions from filters, which this doesn't do. Still, if that's what it takes...

Unfortunately there's no INSTRUMENT_CODE on my portfolio table, so I haven't tested David Fitzjarrell's suggestions.

Thanks again
Peter Received on Wed Jun 15 2005 - 03:02:14 CDT