"sasha" <[EMAIL PROTECTED]> wrote: > > SELECT I.* > FROM "RssFeedItems" I > LEFT JOIN (SELECT MIN(RDB$DB_KEY) AS ENCLOSURE_KEY, "FeedItemId" FROM > "RssFeedItemEnclosures" GROUP BY "FeedItemId") > AS EN ON EN."FeedItemId" = I."Id" > LEFT JOIN "RssFeedItemEnclosures" E ON E.RDB$DB_KEY = EN.ENCLOSURE_KEY > JOIN "RssCacheElements" RCE ON I."FeedId" = RCE."RssFeedId" > WHERE RCE."FeedDefinitionId" = 1540 > > åÓÌÉ ÖÅ ÐÏÓÔÁ×ÉÔØ INNER JOIN ÄÏ LEFT, ÔÏ ×Ó£ ÎÁÞÉÎÁÅÔ ÌÅÔÁÔØ.
óÔÁÒÁÑ ÉÚ×ÅÓÔÎÁÑ ÇÒÁÂÌÑ. ðÉÛÉ ÔÁÂÌÉÃÙ × ÐÏÒÑÄËÅ Ó×ÑÚÙ×ÁÎÉÑ, Á ÎÅ ËÁË ÐÏÐÁÌÏ - ÓÜËÏÎÏÍÉÛØ ÎÅÒ×Ù. ðÏÓÌÅÄÎÉÊ INNER Õ ÔÅÂÑ Ó E ÎÉËÁË ÎÅ Ó×ÑÚÁÎ, ÔÁË ÎÁÆÉÇÁ ÅÇÏ ÐÏÓÌÅ ÓÔÁ×ÉÔØ? > üÔÏÔ ÁÓÐÅËÔ Ñ ÎÅ ÏÞÅÎØ ÐÏÎÉÍÁÀ. ñ ÏÖÉÄÁÌ ÞÔÏ ÏÔ ÐÅÒÅÍÅÎÙ > ÍÅÓÔ ÄÖÏÊÎÏ× ÐÌÁÎ ÎÅ ÄÏÌÖÅÎ ÉÚÍÅÎÉÔÓÑ. îÅ ÄÏÌÖÅÎ. îÏ ×ÓÅÇÄÁ ÍÅÎÑÌÓÑ É ÄÏ ÓÉÈ ÐÏÒ ÍÅÎÑÅÔÓÑ. > ôÅÐÅÒØ ×ÅÒΣÍÓÑ Ë ÚÁÐÒÏÓÕ Ó ÐÒÅÄÓÔÁ×ÌÅÎÉÅÍ. á ×ÏÔ ÔÕÔ Ñ ÂÙ ×ÚÇÌÑÎÕÌ ÎÁ ÂÁÚÕ. -- äÍÉÔÒÉÊ åÍÁÎÏ×
