problem in join query

Question

0.00/5 (No votes)

See more:

Hi friends
the below is my join query for getting some result

SQL

create procedure sp_bindexamclass(@classid int,@examid int)
as
begin
select en.ExamName,St.Standered_name,Sr.SubjectName,ec.Maximummark,ec.Minimummark from Standered_details St inner join ExamClasssetting_details ec on St.Standered_id=ec.Classid inner join SubjectRegistration_details Sr on Sr.SubjectCode=ec.subjectid inner join ExamNameSetting_details en on en.ExamId=ec.ExamId where ec.Classid=@classid and ec.ExamId=@examid

end

Table relation is

1.standered details
relational key is

standered_id

to

classid

(fk) of Examclasssetting_details
2.SubjectRegistration_details
relational key is

subjectcode

to

subjectid

of
Examclasssetting_details
3 .ExamNamesetting_details
relational key is

ExamId

to

ExamId

of Examclasssetting_deatails

all the table contains data for join query. but i couldnt get the desired result. what is the problem in join query.

Posted 8-Dec-12 0:00am

baskaran chellasamy

Updated 8-Dec-12 0:33am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patel Shailendra · Answer 1 · 2012-12-08T17:50:00

create procedure sp_bindexamclass(@classid int,@examid int)
as
begin
select en.ExamName,St.Standered_name,Sr.SubjectName,ec.Maximummark,ec.Minimummark
from Standered_details St
inner join ExamClasssetting_details ec on ec.Classid =St.Standered_id and ec.Classid=@classid and ec.ExamId=@examid
inner join SubjectRegistration_details Sr on ec.subjectid =Sr.SubjectCode
inner join ExamNameSetting_details en on en.ExamId=ec.ExamId
end

Try This one.

Note:Where we create join at that time on clause work as where class for that given table so keep all the condition related to that table after on.

If you use any join then where condition is for first table for eg. in this join Standered_details condition you can write in where clause.