"Oleg Prosvetov" <[email protected]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[email protected]... > ÷ÏÔ ×ÙÄÅÒÖËÁ ÉÚ ÓÐÒÁ×ËÉ 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
á ÞÔÏ ÂÕÄÅÔ, ÅÓÌÉ ÅÓÔØ Ä×Å Ó×ÑÚÉ ÐÏ ×ÎÅÛÎÅÍÕ ËÌÀÞÕ ÍÅÖÄÕ ÜÔÉÍÉ ÔÁÂÌÉÃÁÍÉ? é ×ÏÏÂÝÅ, ËÁËÏÊ ×ÙÉÇÒÙÛ × ÉÓÐÏÌØÚÏ×ÁÎÉÉ ÜÔÏÊ ËÏÎÓÔÒÕËÃÉÉ? -- ÷ÌÁÄ
