subject:"Error upon order by with group by and join"

RE: Error upon order by with group by and join

2001-01-30 Thread Quentin Bennett

with group by and join Hi, I am using mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686). When I try to run the following query: select tb1.fname, tbl1.lname, tbl2.appID, count(tbl2.appID) as count from tbl1, tbl2 where tbl1.id = tbl2.appID group by tbl2.appID order by tbl1.fname I get

Error upon order by with group by and join

2001-01-30 Thread Chana Black

Hi, I am using mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686). When I try to run the following query: select tb1.fname, tbl1.lname, tbl2.appID, count(tbl2.appID) as count from tbl1, tbl2 where tbl1.id = tbl2.appID group by tbl2.appID order by tbl1.fname I get the following error: ERR