Hello, All! îÅÔ ÌÉ × Firebird ÁÎÁÌÏÇÁ ËÏÎÓÔÒÕËÃÉÉ KEY JOIN ÉÚ Sybase Adaptive Server Anywhere. åÓÌÉ ÎÅÔ, ÔÏ ÎÅÌØÚÑ ÌÉ ÓÄÅÌÁÔØ (ÍÏÖÅÔ, × ÕÐÒÏÝÅÎÎÏÊ ÆÏÒÍÅ). KEY JOIN ÍÏÇ ÂÙ ÂÙÔØ ÐÏÌÅÚÎÅÅ, ÞÅÍ ÕÖÅ ÒÅÁÌÉÚÏ×ÁÎÎÙÊ NATURAL JOIN, ÔÁË ËÁË ÉÓÐÏÌØÚÕÅÔ Ñ×ÎÕÀ ÉÎÆÏÒÍÁÃÉÀ Ï Ó×ÑÚÉ ÔÁÂÌÉà ÉÚ DDL, Á ÎÅ ÓÏ×ÐÁÄÅÎÉÅ ÉÍÅÎ, ËÏÔÏÒÏÅ ÍÏÖÅÔ ÐÒÏÉÚÏÊÔÉ É ÓÌÕÞÁÊÎÏ. õÎÉ×ÅÒÓÁÌØÎÏÊ ÂÙÌÁ ÂÙ "ÇÉÂÒÉÄÎÁÑ" ËÏÎÓÔÒÕËÃÉÑ: <table reference> <join type> JOIN <table reference> USING ( <key name> )
÷ÏÔ ×ÙÄÅÒÖËÁ ÉÚ ÓÐÒÁ×ËÉ Sybase ÐÒÏ KEY JOIN: / **************************************************************** ðÒÉ ÏÐÒÅÄÅÌÅÎÉÉ ËÌÀÞÅ×ÏÇÏ ÓÏÅÄÉÎÅÎÉÑ Adaptive Server Anywhere ÇÅÎÅÒÉÒÕÅÔ ÕÓÌÏ×ÉÅ ÓÏÅÄÉÎÅÎÉÑ, ÏÓÎÏ×ÁÎÎÏÅ ÎÁ Ó×ÑÚÑÈ ÐÏ ×ÎÅÛÎÅÍÕ ËÌÀÞÕ × ÂÁÚÅ ÄÁÎÎÙÈ. äÌÑ ÉÓÐÏÌØÚÏ×ÁÎÉÑ ËÌÀÞÅ×ÏÇÏ ÓÏÅÄÉÎÅÎÉÑ ÎÅÏÂÈÏÄÉÍÏ ÎÁÌÉÞÉÅ Ó×ÑÚÉ ÐÏ ×ÎÅÛÎÅÍÕ ËÌÀÞÕ ÍÅÖÄÕ ÔÁÂÌÉÃÁÍÉ, × ÐÒÏÔÉ×ÎÏÍ ÓÌÕÞÁÅ ×ÙÄÁÅÔÓÑ ÏÛÉÂËÁ. îÁÐÒÉÍÅÒ, ÓÌÅÄÕÀÝÉÊ ÚÁÐÒÏÓ Ñ×ÌÑÅÔÓÑ ÐÒÏÓÔÙÍ ËÌÀÞÅ×ÙÍ ÓÏÅÄÉÎÅÎÉÅÍ, Ó×ÑÚÙ×ÁÀÝÉÍ ÔÁÂÌÉÃÙ product É sales_order_items ÎÁ ÏÓÎÏ×Å Ó×ÑÚÉ ÐÏ ×ÎÅÛÎÅÍÕ ËÌÀÞÕ × ÂÁÚÅ ÄÁÎÎÙÈ: SELECT * FROM product KEY JOIN sales_order_items óÌÅÄÕÀÝÉÊ ÚÁÐÒÏÓ ÜË×É×ÁÌÅÎÔÅÎ: SELECT * FROM product JOIN sales_order_items ON sales_order_items.prod_id = product.id ***********************************************************/ ---- With best regards, Oleg Prosvetov.