this SQL works select 1 as *`data.group`* from tbl group by *data.group*
Since there's no such field as *data,* I thought the SQL has to look like this select 1 as *`data.group`* from tbl group by `*data.group`* But that gives and error (cannot resolve '`data.group`') ... I'm no expert in SQL, but feel like it's a strange behavior... does anybody have a good explanation for it ? Thanks -- Kohki Nishio