Home » RDBMS Server » Server Administration » Re: SQL Server 7 statement to Oracle 8i
Re: SQL Server 7 statement to Oracle 8i [message #375104] Thu, 26 July 2001 05:27
Stefano Tempesta
Messages: 3
Registered: July 2001
Junior Member
The right SQL statement is the follow one:

SELECT M.ID, M.ID_course, M.ID_user, M.Subject, M.Date,
M.ID_parent, M.Attachment, U.login AS UserName,
O.Sign AS Sign, Utenti.ID AS USERID, M.Body
FROM ((ForumMessages M INNER JOIN
Utenti U ON M.ID_user = U.ID) CROSS JOIN
Utenti) LEFT JOIN
ForumOutlook O ON (M.ID = O.ID_message AND
Utenti.ID = O.ID_user)

Report message to a moderator

Previous Topic: Use SQL*Plus to update a part of a string or value
Next Topic: Re: specify which position on a line to start printing a string
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:12:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.