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
Joma Rajab
NA
110
51.9k
Hoe to make a selected column distinct in inner join
Aug 16 2016 7:54 AM
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
Reply
Answers (
9
)
How to find a database peek hours in a day?..
How to delete from more than one table