> íÏÖÎÏ left join ÉÓÐÏÌØÚÏ×ÁÔØ É "where t2.somefield is null", ÏÄÎÁËÏ, not > exists ÌÕÞÛÅ imho. óÐÅÃÉÁÌØÎÏÇÏ ÏÐÅÒÁÔÏÒÁ (ËÒÏÍÅ not exists) ÎÅ > ÐÒÉÐÏÍÉÎÁÀ.
ÞÅÍ ÜÔÏ not exist ÌÕÞÛÅ??? ÅÓÌÉ Ñ ×ÓÅ ÐÒÁ×ÉÌØÎÏ ÐÕÔÁÀ, ÔÏ îïô åëúéóô ×ÙÐÏÌÎÑÅÔ ×ÙÂÏÒËÕ ÚÁÐÉÓÅÊ ÎÁ ËÁÖÄÕÀ ÚÁÐÉÓØ ÐÅÒ×ÏÊ ÔÁÂÌÉÃÙ × ÔÏ ×ÒÅÍÑ, ËÁË ìåæô äöïêî ÅÄÉÎÏÖÄÙ ÏÂßÅÄÉÎÑÅÔ Ä×Å ×ÙÂÏÒËÉ not exist ÍÏÖÅÔ ÄÁÔØ ×ÙÊÇÒÙÛØ ÔÏÌØËÏ ÅÓÌÉ ÔÅÂÅ ÎÁÄÏ ÎÅÓËÏÌØËÏ ÐÅÒ×ÙÈ ÚÁÐÉÓÅÊ ÉÚ ÓÒÁ×ÎÉÔÅÌØÎÏ ÂÏÌØÛÏÊ ×ÙÂÏÒËÉ