1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    What is the exact error it returns?
     

Share This Page