Tech
Forums
Jobs
Books
Events
Live
Learn
More
Training
Interviews
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
9
Reply
Hoe to make a selected column distinct in inner join
Joma Rajab
Aug 16 2016 7:54 AM
305
Reply
I need to make one column distinct in inner join three tables
I need to make videoName distinct y only not other colunms
how can I write the query
please help
SElECT distinct t1.MID, distinct t1.VideoName, t2.*,t3.UniID,t3.user_type from dbo.Material AS t1 INNER JOIN dbo.ModuleRelation As t2 ON t2.MID=t1.MID INNER JOIN dbo.Users AS t3 ON t3.UniID=t2.UId where t3.user_type=
'Staff'
and t1.IsDeleted = 0 AND t2.MID=
'CM1034D'
;
thanks
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
9
)
Next Recommended Forum
How to find a database peek hours in a day?..
How to delete from more than one table