Thanks, Dennis, I'll try that. Yes, "*=" means "LEFT JOIN" in sybase syntax.
-----Original Message----- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 4:55 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] help with syntax Anderson, James H (IT) wrote: > I have the following sybase query (a left join) that I'm having trouble > translating into the "LEFT JOIN" syntax. Any help appreciated. > > Thanks, > jim. > > > create table tmpRR_ML as > select > b.ratingCode as ratingCode, > a.CDSpreadCurve as CDSpreadCurve > from tmpRR a, > MasterList b, > crRefRating c > where b.dunsNumber = b.ultimateDuns; > and a.Credit_Ultimate_Party_Id *= b.dunsNumber > and b.ratingCode *= c.rating; > -------------------------------------------------------- > > NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. > > James, I suspect this should be the following for SQLite, but I'm just guessing at the *= syntax from sybase. create table tmpRR_ML as select b.ratingCode as ratingCode, a.CDSpreadCurve as CDSpreadCurve from tmpRR a left join MasterList b on a.Credit_Ultimate_Party_Id = b.dunsNumber left join crRefRating c on b.ratingCode = c.rating where b.dunsNumber = b.ultimateDuns; HTH Dennis Cote ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
