¥È¥Ã¥× «Á°¤ÎÆüµ­(2005-11-09) ºÇ¿· ¼¡¤ÎÆüµ­(2005-11-16)» ÊÔ½¸

¥µ¥¤¥é¥¹¤ÎËÜê


2005-11-15

¡¦ [SQL] INNER JOIN¤Î¥µ¥ó¥×¥ë

SELECT  T_Hoge.ID, T_Foo.sNo, T_Foo.sSalesCompanyName, T_Foo.nQuantity, 
        T_Hoge.sPurchaseKey, T_Foo.sAddress
FROM    T_Hoge INNER JOIN
        T_Foo ON T_Hoge.ID = T_Foo.ID