Quiery

Discussion in 'SQL Server' started by itsys, May 25, 2009.

  1. itsys

    itsys Banned

    Joined:
    May 2, 2009
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    0
    SELECT Persons.Name, Persons.Address, Orders.OrderNo
    FROM Persons
    INNER JOIN Orders
    ON Persons.P_Id=Orders.P_Id
    ORDER BY Persons.Name



    Table Persons
    P_Id Name Address
    1 kammo India
    2 kamal USA

    Table Orders
    OrderNo O_ID P_Id
    9 1 2
    5 2 5


    When run quiery so create error Why?
    Plz Resolove my Problem
    Thanks,
     
    Last edited by a moderator: May 25, 2009
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    48
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    What is the exact error it returns?
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice