>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.
