RE: [LUG] FW: MySQL Query problems

["Robin Cornelius" <robin@xxxxxxxxxxxxxxxxxxxxx>]

> You need an outer join.
>
> Eg.
>
> SELECT pinksheet.requirment,contact.phone,contact.fax
> FROM contact
> LEFT JOIN pinksheet ON contact.PKey = pinksheet.contactid

That works perfectly, thanks! It seems to require a lot of horsepower
however but this should improve when I add some more where clauses in to
restrict the data set a bit.

Regards

Robin@xxxx


--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe.