Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unhappy Unanswered: Any problem with my SQL Statement ?

    I wrote sql statement like here :

    SELECT GRHDR.StartUpMenu, USP.HTTPMailPath FROM SA.GROUPHDR GRHDR INNER JOIN SA.USERPROFILE USP ON GRHDR.GroupID = USP.GroupID WHERE (((USP.UserID)=N'KALIM'))


    But oracle said that "SQL command not properly ended".....
    what's wrong ? I can run this statement on MS Access, SQL Server, and MySQL......

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Try this Query,

    SELECT GRHDR.StartUpMenu
    , USP.HTTPMailPath
    FROM SA.GROUPHDR GRHDR
    , SA.USERPROFILE USP
    WHERE
    GRHDR.GroupID = USP.GroupID and
    (((USP.UserID)=N'KALIM'))
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    ok it works.... thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •