score:0

Accepted answer
var query = (
    from a in db.record_holddata
    join b in db.flavortable on
        a.flavorid equals b.id
    where a.holdstatus == "open"
    select
        new
        {
            a.dateopened,
            a.field1,
            a.field2,
            ...
            b.flavorname
        })
    .tolist();

Related Query

More Query from same tag