score:1

Accepted answer
var id_posts = from p in db.posts
           join hp in db.have_privacy on p.id_post equals hp.id_post
           join prv in db.privacy on hp.id_privacidade equals prv.id_privacidade
           where prv.nome = 'private'
           select p.texto;

score:0

var id_posts = from p in db.posts
           join hp in db.have_privacy on p.id_post equals hp.id_post
           join prv in db.privacy on hp.id_privacidade equals prv.id_privacidade
           where prv.nome = 'private'
           select p.texto;

Related Query

More Query from same tag