Re: FN-FORUM: Sql query help

date posted 13th January 2004 12:09

> >Change the INNER JOIN to LEFT OUTER JOIN then ?
>
> That looks to be the one!
>
> Have a pint on me.

ta ;)

Sorry I wasn't following the thread properly - I thought from the initial
message that you only wanted suppliers with products with null values.

> Do you know any good tutorials on the JOIN syntax? I've never been able to
> get my head around it.

Oddly I find writing JOINs easier than trying to understand the tutorials so
hopefully someone else can help us out there :)
I can explain why that SQL works if it'd be of any help - but I just learnt
initially by building views in SQL Server and seeing what SQL they made,
then trying to solve problems like that one using a single query - it falls
into place after a bit.

Andy