From: Peter Brawley
Date: December 12 2012 1:48am
Subject: Re: Help with left outer join
List-Archive: http://lists.mysql.com/mysql/228793
Message-Id: <50C7E255.7030601@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------040509010602070706060108"

--------------040509010602070706060108
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >ERROR 1054 (42S22): Unknown column 'data_tool.category_id' in 'on clause'
 >But category_id is a column in data_tool.

Then a bit of reordering is required ...

SELECT data_target.name, ep, wafer_id, lot_id,
        date_time, data_file_id, data_cstimage.name,
        bottom, wf_file_path_id, data_measparams.name,
        vacc, data_category.name
FROM data_cst
RIGHT JOIN data_cstimage   ON data_cstimage.id = data_cst.image_measurer_id
INNER JOIN data_tool       ON data_tool.id = data_cst.tool_id
INNER JOIN data_target     ON data_target.id = data_cst.target_name_id
INNER JOIN data_measparams ON data_measparams.id = 
data_cst.meas_params_name_id
INNER JOIN data_category   ON data_category.id = data_tool.category_id
WHERE data_cst.target_name_id IN (38018, 29947, 28330)
   AND data_cst.date_time BETWEEN '2012-09-01 00:00:00' AND '2012-09-07 
00:00:00'
ORDER BY target_name_id, ep, wafer_id, lot_id, date_time;

PB

----

On 2012-12-11 5:11 PM, Larry Martell wrote:
>> SELECT data_target.name, ep, wafer_id, lot_id,
>> >
>> >        date_time, data_file_id, data_cstimage.name,
>> >
>> >        bottom, wf_file_path_id, data_measparams.name,
>> >
>> >        vacc, data_category.name
>> >
>> >FROM data_cst
>> >
>> >RIGHT JOIN data_cstimage   ON data_cstimage.id = data_cst.image_measurer_id
>> >
>> >INNER JOIN data_target     ON data_target.id = data_cst.target_name_id
>> >
>> >INNER JOIN data_measparams ON data_measparams.id =
>> >data_cst.meas_params_name_id
>> >
>> >INNER JOIN data_category   ON data_category.id = data_tool.category_id
>> >
>> >INNER JOIN data_tool       ON data_tool.id = data_cst.tool_id
>> >
>> >WHERE data_cst.target_name_id IN (38018, 29947, 28330)
>> >
>> >    AND data_cst.date_time BETWEEN '2012-09-01 00:00:00' AND '2012-09-07
>> >00:00:00'
>> >
>> >ORDER BY target_name_id, ep, wafer_id, lot_id, date_time;
> Thanks very much for the reply. This is giving me:
>
> ERROR 1054 (42S22): Unknown column 'data_tool.category_id' in 'on clause'
>
> But category_id is a column in data_tool.
>
>


--------------040509010602070706060108--