Mike Gifford wrote:
> However, when I run this query:
>
> mysql_query("SELECT
> WLPbib.bibID,
> WLPbib.title,
> WLPbib.publisher,
> WLPbib.publicationDate,
> WLPaddress.city,
> WLPaddress.state,
> WLPprofile.firstName,
> WLPprofile.lastName,
> WLPprofile.organization,
> WLPcountry.languageName
> FROM WLPbib
> LEFT JOIN WLPprofile ON WLPprofile.profileID = WLPbib.profileID
> LEFT JOIN WLPaddress ON WLPaddress.publisherID = WLPbib.publisherID
> LEFT JOIN WLPcountry ON WLPcountry.countryID = WLPaddress.countryID");
>
> I now get results in triplicate. ie. I'm getting three copies of the same
> title, firstName, organization, etc....
>
> I somehow suspected that this should be the result with LEFT JOIN, but I'm not
> sure how to return a query without duplication.
>
> This is far better than what I had this morning (which was no response from the
> server).
>
> Thanks. I'm new to joining tables...
>
> Mike
> --
Maybe SLECT DISTINCT ... could help you.
Kamil
--
----------------------------------
[EMAIL PROTECTED]
----------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
