Skip navigation links

MySQL Forums :: MySQL Query Analyzer :: Can't get LEFT JOIN query to work


Advanced Search

Re: Can't get LEFT JOIN query to work
Posted by: Oliver Candelario ()
Date: April 23, 2012 01:06AM

You included the additionalPersonalItems table from your SELECt statment and yet you did not use it. The field folder in your WHERE will also generate ambigous error. It should be personalItems.folder='mcmorris'

Options: Reply•Quote


Subject Views Written By Posted
Can't get LEFT JOIN query to work 739 Travis McDonald 04/20/2012 10:53AM
Re: Can't get LEFT JOIN query to work 428 Oliver Candelario 04/23/2012 01:06AM


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

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.