"Boulitchev Aleksey" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > >>> ËÓÔÁÔÉ. ÔÒÉÇÇÅÒÙ ÒÁÚÎÙÅ ÂÙ×ÁÀÔ. îÁ ÏÐÅÒÁÔÏÒ - ÒÁÚ, >>> É ÎÁ ÚÁÐÉÓØ - Ä×Á. ñ ÔÁË ÐÏÎÑÌ, ÉÄÅÑ × "ÔÒÉÇÇÅÒÅ ÎÁ ÓÅÌÅËÔ" - >>> ÜÔÏ ÔÒÉÇÇÅÒ, ÓÒÁÂÁÔÙ×ÁÀÝÉÊ ÎÁ ËÁÖÄÕÀ ÚÁÐÉÓØ. ôÁË? >>> á ËÁË "ÂÙÓÔÒÏ" ÜÔÏ ×ÓÅ ÂÕÄÅÔ ÒÁÂÏÔÁÔØ, ÐÒÅÄÓÔÁ×ÌÑÅÍ? >> >> ôÒÉÇÇÅÒ ÎÁ ÏÐÅÒÁÔÏÒ ÜÔÏ ×ÓÅ ÔÁËÉ ÐÒÁ×ÉÌØÎÅÅ >> ïÔ×ÌÅÞÅÎÎÏ ÔÁË ... ;-) > > create table TEST( > ID integer, > NAME varchar(10)) > > > select * > from (select ID, NAME from TEST t) t1 > join TEST t2 on t1.ID = t2.ID > where t1.ID in (select t3.ID from TEST t3 where t3.ID > 3) and > exists (select * from TEST t4 where t4.ID = t1.ID) > > ËÕÄÙ ÓÔÒåÌØÎÅÔ?
á DELETE FROM DELETE ÓÌÁÂÏ ÁÎÁÌÏÇÉÞÎÙÊ ? :) óÏÒÒÉ ÚÁ ÍÉÚÁÎÄÅÒÓÔÅÎÄÉÎ, Ñ ÎÅ ÐÒÏ ÉÓÈÏÄÎÕÀ ÉÄÅÀ ÎÁÓÞÅÔ ÔÒÉÇÇÅÒÏ× ÎÁ ÓÅÌÅËÔ. Regards, Aleksey Karyakin
