Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
IN Operator how to use MySQL
Karthick Ayyam
Sep 13 2017 12:54 AM
188
Reply
how to ssrs report include the IN opertor
SELECT DISTINCT s.time_ref, s.time_date, s.time_hrs, s.time_emp, e.emp_code, e.emp_firstname, i.WBSACTIVITY
FROM site_timesheet s, site_employee_master e, in_wbs_master i
WHERE (time_date BETWEEN ? AND ?) AND (s.time_emp = e.emp_id) AND (s.time_act = i.WBSCDE) AND
(emp_code IN (?))
GROUP BY s.time_emp, s.time_ref, s.time_date, s.time_type, i.WBSACTIVITY, s.time_hrs, e.emp_firstname
Error Multivalue Not accept in Emp_code
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Self join on three columns with conditions
I want to build smart search (like e-commerce autocomplete)