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