I have this sql mapping to an xml file where the sql query is.
In the statement, I needed to get an additional column value from another unrelated table. Like tables A and B are not related (so no way of joining).
Therefore, my statement is like:
SELECT ax, ay, az, bm
FROM A, B
WHERE bn = 'p'
It runs fine in SQL query window.
But when I run it from my program - I get this error:
SqlException (0x80131904) in SqlMap: Incorrect syntax near the keyword 'WHERE'.
Anybody any ideas?