MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Querying multiple tables with one Query
Posted by: Rick James
Date: August 01, 2014 11:34PM

JOIN description ON scpart.scpart = description.scpart
-->
JOIN description ON part_number.scpart = description.scpart

SHOW CREATE TABLE -- it sounds like you are missing some indexes.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Querying multiple tables with one Query
James Hartwell
July 31, 2014 08:52AM
Re: Querying multiple tables with one Query
Rick James
August 01, 2014 11:34PM
Re: Querying multiple tables with one Query
James Hartwell
August 05, 2014 01:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.