I portaded my Application from the MS SQL Server 7.0 to MySQL 3.23.54 and
i'm having problems with the both syntax.
How can i do this query in MySQL Server Syntax:
"select sld_vlprov,hist_lanc from sld_lanc,lanc
where sld_lanc.sld_user *= lanc.user_usuario and
dt_movlanc > '02/12/03'"
This query must return one row. In the first column have a float value and
in the second column a null value.
This query retuns one row in MS SQL Server with the syntax above, but
returns no rows when traduced to MySQL Server syntax below:
"select * from sld_lanc left outer join lanc on sld_lanc.sld_user =
lanc.user_usuario
where dt_movlanc > '02/12/03'"
I'm waiting for help.
Thank's to evrybody and I wish a Merry Christimas.
Um abraço,
Samuel Meira
[EMAIL PROTECTED]
_________________________________________________________
Voce quer um iGMail protegido contra vírus e spams?
Clique aqui: http://www.igmailseguro.ig.com.br
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
