Hi Max,
Maxim Maletsky wrote:
not to give you the solution, but there's something you can simplify in your
query:
USING(field)
I like the idea of using USING... however I've run into some problems.
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 USING(profileID)
LEFT JOIN WLPaddress USING(publisherID)
LEFT JOIN WLPcountry USING(countryID));
simplier, right?
Simpler yes, however it produces this error:
MySQL Error: 1054 (Unknown column 'WLPprofile.publisherID' in 'on clause')
Because although WLPbib is linked to WLPprofile WLPaddress it is not linked to
WLPcountry. WLPaddress needs to be linked to WLPcountry.
How does one specify that?
as of your problem, let me think, I had the same problem couple month ago.
I'll look int omy codes.
I hear ya.. Somewhere, within which project lies the answer (likely).. Now
which one? :)
Thanks for looking into it.
Mike
-Original Message-
From: Mike Gifford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 1:04 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Duplication Results When LEFT JOIN is Used Between
Multiple Tables
Hello,
I'm making some headway on joining three MySQL tables. (Thanks to responses
from this list early this morning)
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
--
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein
--
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]
--
Mike Gifford, OpenConcept Consulting, http://openconcept.ca
Offering everything your organization needs for an effective web site.
Abolish Nuclear Weapons Now!: http://pgs.ca/petition/
It is a miracle that curiosity survives formal education. - A Einstein
--
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]