TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Devendra Kumar
NA
517
244.5k
use where clause in with inner join in sqlserver
May 19 2016 8:21 AM
how to use multiple where clause like
first i select values there feedback is not null
select
*
FROM
Tbl_Work
INNER JOIN
Tbl_Client
ON
Tbl_Work.Client_Id = Tbl_Client.Client_Id
INNER JOIN
Tbl_Employee
ON
Tbl_Work.Id = Tbl_Employee.Id
where
Feedback
is not null
then i want to select in these selected value
query like this but not work :
select * From (select
*
FROM
Tbl_Work
INNER JOIN
Tbl_Client
ON
Tbl_Work.Client_Id = Tbl_Client.Client_Id
INNER JOIN
Tbl_Employee
ON
Tbl_Work.Id = Tbl_Employee.Id
where
Feedback
is not null)
where
Company_Name
Like
'%'+@SearchString+'%' or Department_Name
Like
'%'+@SearchString+'%'
given error
please help
Reply
Answers (
2
)
Mobile OTP Generation
MVC and Bootsratp