Devart Forums

I have a MySQL query that successfully executes in the MySQL Query Browser, but when I include this query in the Query Builder of Table Adapter, I get the error:

“Error in GROUP BY clause. Unable to parse query text.”

Here is the query. Any ideas what the problem is?

Thanks,
Griff

SELECT id, MAX(trade_date) AS MaxTradeDate
FROM (SELECT overnight_position_option.trade_date, `option`.security_id, `security`.id, `security`.name
FROM (`security` INNER JOIN
(`option` INNER JOIN overnight_position_option
ON `option`.security_id = overnight_position_option.security_id)
ON `option`.underlier_id = `security`.id)) AS LastTrade
GROUP BY id;

Could you please post or send me (alexeyman*crlab*com) the tables definition script?