mysql - Need to display records by joining two tables and the records should be Unique -


i have 2 tables student , taskeffort.

many students have worked on same tasks. particular task name of students , effort should considered.

the student table contains studentid, firstname , lastname.

the taskeffort table contains taskid, studentid , effort

i need display taskid, first name, last name, effort, worked on particular task.

this 1 of queries tried, not working.

select t.id, s.firstname, s.lastname, t.effort  taskeffort t  left outer join student s on t.id = 4 , s.studentid = t.studentid 

thanks in advance.

select t.id, s.firstname,s.lastname, t.effort  taskeffort t  left outer join student s on s.studentid = t.studentid  t.id = 4; 

Comments

Popular posts from this blog

xml - Extract substrings with XSLT -

math - "ELO Rating" and how does "TSR Rating" work? -

How can do a tuple comparison in coffeescript similar to that in python? -