sql query not working

Question

0.00/5 (No votes)

See more:

my first query is not working and second is working but i want to search a member through group id

SQL

select m.mId,(mFName+' '+isnull(mLName,'')) as mname,s.subCatName,s.subCatId,
 mAdd,
   mContact,mCity,mFather,mQual from tblMemberDetail m
 inner join tblMemberCourse c on m.mId=c.mId
 inner join tblSubCategory s on c.subcatId=s.subCatId
 where mActive = 1 and m.mId=1

SQL

select m.mId,(mFName+' '+isnull(mLName,'')) as mname,
g.gName, mAdd,
   mContact,mCity,mFather,mQual from tblMemberDetail m
 inner join tblMemberCourse c on m.mId=c.mId
 inner join tblGroup g on c.gId=g.gId
 where mActive = 1 and m.mId=1

Posted 19-Dec-12 20:23pm

Miss Maheshwari

Updated 19-Dec-12 20:47pm

v4

Add a Solution

Comments

__TR__ 20-Dec-12 2:57am

What do you mean by "not working" ? Are you getting any error ?
We need some more details on what is it you are trying to do.

ZeroCoding 20-Dec-12 3:13am

Have you checked that the subcatId returned by tblMemberCourse actually exists in tblSubCategory?

More info

1 solution

Add a Solution

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

kanyogendra · Answer 1 · 2012-12-21T05:57:00

Hi,

Both the Query are ok ,

In case if Query is not returning any row then possible reason is that
tblSubcategory don't have record for MemberID : 1 ;

you may use left join in such case as

SQL

select m.mId,(mFName+' '+isnull(mLName,'')) as mname,s.subCatName,s.subCatId,
 mAdd,
   mContact,mCity,mFather,mQual from tblMemberDetail m
 inner join tblMemberCourse c on m.mId=c.mId
 left join tblSubCategory s on c.subcatId=s.subCatId
 where mActive = 1 and m.mId=1

Thanks !
Yogendra Dubey

sql query not working

1 solution

Solution 1

Add your solution here

Preview 0

sql query not working

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us