Вот такого плана:
<div class='XPPtop'>X++</div><div class='XPP'>
qu =[color=:blue]new[/color] Query();
qbds_R = qu.addDataSource([color=:blue]tablenum[/color](Table_1));
qbds_R.addRange([color=:blue]fieldnum[/color](Table_1,BooleanField)).value([color=:red]"1"[/color]);
qbds_I = qbds_R.addDataSource([color=:blue]tableNum[/color](Table_2));
qbds_I.addLink([color=:blue]fieldnum[/color](Table_1, IdField), [color=:blue]fieldnum[/color](Table_2, IdField));
qbds_I.addRange([color=:blue]fieldnum[/color](Table_2, Direction)).value([color=:red]"1"[/color]);
qbds_I.addRange([color=:blue]fieldnum[/color](Table_2, StatusReceipt)).value([color=:red]"!1,!2"[/color]);
qbds_I.joinMode(JoinMode::NoExistsJoin);
this.query(qu);
this.executeQuery();</div>