Samuel, > select sld_vlprov,hist_lanc from sld_lanc,lanc > where sld_lanc.sld_user *= lanc.user_usuario
In MySQL, this could simply be: select sld_vlprov,hist_lanc from sld_lanc,lanc where sld_lanc.sld_user = lanc.user_usuario But you can write it like you did, as well: > select * from sld_lanc left outer join lanc on sld_lanc.sld_user = > lanc.user_usuario > where dt_movlanc > '02/12/03' The problem lies within the date part. A date in MySQL should be in the format "YYYY-MM-DD" (international format). Other formats like "YY/MM/DD" are supported, too, which you can find at: http://www.mysql.com/documentation/mysql/bychapter/index.html#Date_and_t ime_types Your date appears to be in the format "DD/MM/YY" (ancient German) or "MM/DD/YY" (contemporary American), both of which do not work in MySQL. If it's the latter (my guess) you will have to rewrite it like this: 2003-02-12 or 03-02-12 Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 25, 2002 12:10 AM Subject: syntax > 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 > --------------------------------------------------------------------- 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
