sql - I want to join tables but still receive results from one table even if the other table has no results -

i'm doing in chrome webdb/sqlite

i have members table , answer table member may or may not have answered.

i trying result set includes member name , answer gave.. if didnt give answer, still want name come back.

can try , me on this?

select m.lastname, m.firstname, m.middlename, s.surveyanswer members m left join surveyanswers s on s.memberid = m.id m.id = ? , s.eventid = ? 

[results.rows.item(i).memberid, eventid],

this try still receive members answered question , in surveyanswers table.

make s.eventid part of join rather where clause.

your select statement should more this:

select m.lastname, m.firstname, m.middlename, s.surveyanswer members m left join surveyanswers s on s.memberid = m.id , s.eventid = ? m.id = ?