Quiery

itsys's Avatar
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
Thanks,

Last edited by shabbir; 25May2009 at 16:19.. Reason: Confine links to signatures only
pradeep's Avatar, Join Date: Apr 2005
Team Leader
What is the exact error it returns?