SQL Query Problem

[yousafc#]

What is Wrong in this code

Select * from Studentinfo
Inner Join Admission
On Studentinfo.Studentid= admission.studentid
where Studentid= '1'

Please Help as soon as Possible

What is the error you are getting? My guess is for the Where clause you need StudentInof.Studentid = '1', also is Studentid an int? If so change it to StudentInof.Studentid = 1

[Mitja Bonca]

Some strange sql query. Why would you compare those two table, when you only want to get all the data from Studentinfo table. Admission table has nothing to do here, since you do get any data from Admission table.
So I recommend you to change the query to:

Select * from Studentinfo
where Studentid= '1'

Mitja Bonca, how do you know that the Admission table has nothing to do with the students? Students get admitted, if a student is in the StudentInfo table but is not admitted and you only want the info for students that are admitted, this makes sense.

[Mitja Bonca]

Yes it does. It really does. Sorry.
In this case, your approach is correct.
Even if StudentId field is only in Studentinfo table, it should work.
But if he has the same field name in more then one table, then it will not work.

As far as I can see he has the same name in Admission table too, so your code will do it!

[yousafc#]

Oh Really thanks to stbuchok
It Solved my Problem and i got result with Studentinfo.studentid