Прям так c "!=" и создавать
PHP код:
//Table1 (a int, b int)
//Table2 (a int, c int)
// требуется Query
// select * from table1 t1, table2 t2
// where t1.a = t2.a AND t1.b <> t2.c
Query qu = new query();
QueryBuildDataSource QBDS;
QueryBuildRange qrng;
QueryRun qr;
qbds = qu.addDataSource(tableNum(Table1), "T1");
qbds = qbds.addDataSource(tableNum(Table2),"T2");
qbds.joinMode(joinMode::INNERJOIN);
qbds.addLink(fieldnum(Table1, a), fieldnum(Table2, a));
qrng = qbds.AddRange(fieldnum(Table2, c));
qrng.value('(T1.b != T2.c)');
qr = new queryRun(qu);