Loading

Syntax error (missing operator) in query expression

Sumar Khan

Hello Every One...

I have a following query in Visual Studio 2012 but have problem and didn't work

"select inv_amount-with_amount as with_inv from ( select sum ( Received ) inv_amount from Land_Revenue) inv_amount,( select sum ( amount ) with_amount from Land_Expenses ) with_amount";

Syntax error (missing operator) in query expression 'sum ( Received ) inv_amount'.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth10y ago
Hi,

// Wrong syntax
"select inv_amount-with_amount as with_inv from ( select sum ( Received ) inv_amount from Land_Revenue) inv_amount,( select sum ( amount ) with_amount from Land_Expenses ) with_amount";
// Add as near inv_amount.
"select inv_amount-with_amount as with_inv from ( select sum ( Received ) inv_amount from Land_Revenue) as inv_amount,( select sum ( amount ) with_amount from Land_Expenses ) with_amount";