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