Hi Every Body
I have two tables Related to each other The First one is "tblListInfo" And the other one is "tblStudents"
"ListID" is primery key in the table "tblListInfo" and it is foreign Key in the table "tblStudent"
What I'm trying to do is:
SELECT dbo.tblStudents.Student_ID, dbo.tblStudents.Student_Name, dbo.tblListInfo.List_Level
FROM dbo.tblListInfo INNER JOIN
dbo.tblStudents ON dbo.tblListInfo.ListID = dbo.tblStudents.ListID
WHERE (dbo.tblStudents.Student_Name LIKE 'Ahmed %')
The Result is one Record inspite of more then one record Starts With the Name 'Ahmed'
and the rest is not displayed
Sorry for poor English.
View Complete Post