C# zapytanie join

var innerJoin = from ta in dbContext.TABELA_A
                join tb in  dbContext.TABELA_B on ta.ID equals (decimal)tb.ID_TA
                where ta.NAZWA == "N1" && tb.STATUS == "Nowy"
                select new
                {
                    ID = tb.ID,
                    NAZWA_A = ta.NAZWA,
                    NAZWA_B = tb.NAZWA,
                    STATUS = tb.STATUS
                };

Select...
from tabela_a ta
left join tabela_b tb on tb.id_parent=ta.id
where tb.id_parent is null

select...
from tabela_a ta
where ta.id not in (
 select id_parent from tabela_b
)