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;
TableAdapter MySQL parse error
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24