Sample XML FSM API group_by

Hi  

I am new to building SQL statements using XML to send to FSM. Are there any samples of building a fairly simple query which contains an aggregate function and a group by statement.

I can’t make it work - I keep getting an error

“The argument tableNameIn does not contain a valid value”

The SQL is quite basic

SELECT s.part_id

, s.place_id

, s.[location]

, COUNT(s.part_id) AS stock_qty

FROM dbo.stock s

INNER JOIN dbo.stock_serial_id ss ON (s.part_id = ss.part_id AND s.place_id = ss.place_id AND s.location = ss.location)

WHERE s.part_id = '12345'

AND s.place_id = 'FOOBAR'

AND s.location = 'BARFOO'

AND ss.usable = 'Y'

GROUP BY   s.part_id

, s.place_id

, s.location

, ss.usable

Cheers

Ganners