Re: adding column breaks query

2013-01-28 Thread Larry Martell
Not sure what you mean. On Mon, Jan 28, 2013 at 8:49 AM, Douglas Nelson wrote: > two different fields?? > > Thanks Doug > > SELECT data_ppl.name as 'P/P/L', data_recipe.name as Recipe, > data_cstmeta.date_time as 'Last Run' > FROM data_recipe, data_ppl, data_cstmeta >INNER JOIN (SELECT id,rec

Re: adding column breaks query

2013-01-28 Thread Shawn Green
Hello Larry, On 1/28/2013 10:42 AM, Larry Martell wrote: I have a query that works fine: SELECT data_ppl.name as 'P/P/L', data_recipe.name as Recipe, data_cstmeta.date_time as 'Last Run' FROM data_recipe, data_ppl, data_cstmeta INNER JOIN (SELECT id,recipe_id, MAX(date_time) as MaxDateTime

Re: adding column breaks query

2013-01-28 Thread Larry Martell
On Mon, Jan 28, 2013 at 8:56 AM, Shawn Green wrote: > Hello Larry, > > > On 1/28/2013 10:42 AM, Larry Martell wrote: >> >> I have a query that works fine: >> >> >> SELECT data_ppl.name as 'P/P/L', data_recipe.name as Recipe, >> data_cstmeta.date_time as 'Last Run' >> FROM data_recipe, data_ppl, da