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


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

  1. itsys

    itsys Banned

    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
    Last edited by a moderator: May 25, 2009
  2. pradeep

    pradeep Team Leader

    What is the exact error it returns?

Share This Page