Re: [GENERAL] optimisation of outer join

2001-08-09 Thread Nicholas Piper
On Thu, 09 Aug 2001, Stephan Szabo wrote: > > depos=# explain select cdtitles.title, cdtitles.artist, song, > > fk_products_id, p.title, p.artist from cdsongs, cdtitles left join > > products p on (cdtitles.fk_products_id = p.id) where cdtitles.cdid = > > cdsongs.cdid and song like 'mushroom fest

Re: [GENERAL] optimisation of outer join

2001-08-09 Thread Stephan Szabo
On Thu, 9 Aug 2001, Nicholas Piper wrote: > Hi everyone again ! You've been so useful that I've got more questions > :-) > > Sorry about the width of my posts by the way, I'm presuming it is > preferred to have wide tables than try and wrap them. > > I'm trying to select all rows from a join,

[GENERAL] optimisation of outer join

2001-08-09 Thread Nicholas Piper
Hi everyone again ! You've been so useful that I've got more questions :-) Sorry about the width of my posts by the way, I'm presuming it is preferred to have wide tables than try and wrap them. I'm trying to select all rows from a join, and then also some other rows from a third join if the row