Re: Help with left outer join

2012-12-12 Thread Larry Martell
On Tue, Dec 11, 2012 at 7:22 PM, wrote: > 2012/12/11 16:19 -0500, Larry Martell > I have this query: > > 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_catego

Re: Help with left outer join

2012-12-12 Thread Larry Martell
On Tue, Dec 11, 2012 at 8:48 PM, Peter Brawley wrote: >>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_fil

Re: Help with left outer join

2012-12-12 Thread Larry Martell
On Wed, Dec 12, 2012 at 8:25 AM, Shawn Green wrote: > On 12/11/2012 7:22 PM, h...@tbbs.net wrote: >> >> ... (Are all the distinct "id"s really needed? When one joins on a >> >> field with the same name in both tables, one may use 'USING', and >> only the common field, with neither NULL, shows up i

Re: Help with left outer join

2012-12-12 Thread Shawn Green
On 12/11/2012 7:22 PM, h...@tbbs.net wrote: ... (Are all the distinct "id"s really needed? When one joins on a field with the same name in both tables, one may use 'USING', and only the common field, with neither NULL, shows up in the output.) This is a perfectly acceptable naming convention t

Re: Help with left outer join

2012-12-11 Thread Peter Brawley
>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_m

Re: Help with left outer join

2012-12-11 Thread hsv
2012/12/11 16:19 -0500, Larry Martell I have this query: 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, data_target, data_cstimage, dat

Re: Help with left outer join

2012-12-11 Thread Larry Martell
On Tue, Dec 11, 2012 at 5:12 PM, Peter Brawley wrote: > > On 2012-12-11 3:19 PM, Larry Martell wrote: > > I have this query: > > 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, >vac

Re: Help with left outer join

2012-12-11 Thread Peter Brawley
On 2012-12-11 3:19 PM, Larry Martell wrote: I have this query: 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, data_target, data_cstimage, d