Re: ANSI joins not working...

Hello Peter,

Peter wrote:

> 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...
>

but INSTRUMENTAL_CODE = 'AFI' is a join condition; especial in case of outer join. A filter would apply to the join result, as seen in OP.

greetings Matthias Received on Wed Jun 15 2005 - 16:35:31 CDT