changing mysql query ino sql

[shavy]

I have this query which is in mysql
[code=vb]
symbolQuery = "select symbol,sum(IF(l edger='BUX' or ledger='BU2',ab s(qty)/2,abs(qty))),fe ptrddate "+"from bookkeeping.fep tradesTemp where"+"account != '999997' "+"and feptrddate = '"+dateStr+" ' "+"and symbol != '' "+"group by symbol";
[/code]
I want to change it in sql.....
will therr be any difference?

[r035198x]

I have this query which is in mysql

symbolQuery = "select symbol,sum(IF(l edger='BUX' or ledger='BU2',ab s(qty)/2,abs(qty))),fe ptrddate "+"from bookkeeping.fep tradesTemp where"+"account != '999997' "+"and feptrddate = '"+dateStr+" ' "+"and symbol != '' "+"group by symbol";

I want to change it in sql.....
will therr be any difference?

Moved to MySQL forum.
Please do not post questions in the articles section.

[amitpatel66]

I have this query which is in mysql

symbolQuery = "select symbol,sum(IF(l edger='BUX' or ledger='BU2',ab s(qty)/2,abs(qty))),fe ptrddate "+"from bookkeeping.fep tradesTemp where"+"account != '999997' "+"and feptrddate = '"+dateStr+" ' "+"and symbol != '' "+"group by symbol";

I want to change it in sql.....
will therr be any difference?

There should not be any diff except some changes in syntax. Try changing it and post back in case if you face any error