sql server - Sql Query left outer join -

sql server - Sql Query left outer join -

in sql query below, have 2 tables, documents , document user map. in documents table has columns documentid, documentname , userid; , in doumnent usermap table has documentid , userid. documents create in documenttable (created documentid, userid). documents share other users in documentusermap table (documentid .other userid).here have pass userid sp

my aim want documents other users shared me.

@i_userid int, select doc.userid, doc.documentid, doc.documentname documents doc left outer bring together documentusermapping dum on dum.documentid = doc.documentid , dum.userid != doc.userid

try query

select doc.userid, doc.documentid, doc.documentname documents doc bring together documentusermapping dum on dum.documentid = doc.documentid doc.userid != @i_userid , dum.userid = @i_userid

sql sql-server