因此,在下面的查询中,im通过order_id连接两个表,并显示来自user_orders表的所有值。如下图所示,我试图只显示与order_manager表匹配的order_manager行。public function getUserOrder(){ JOIN user_orders ON order_manager.order
我有一个连接到SQL数据源的GridView,我希望将其显示为主队和客场球队的名称。相反,我只能检索他们的Home_Team_ID和Away_Team_ID,因为它们与两端的Team_ID that is stored in another table.<asp:GridView ID="EnterMatchGridView" runat="server" AutoGenerateColumns="False" DataKeyNa