如何在sql server2005中的产品，类别，购物车，订单的购物车数据库表中进行连接 [英] how to do joins in shopping cart database tables of product, category, cart, order in sql server2005

问题描述

请告诉我如何在购物车数据库中的多个表中创建联接，我的表是产品，类别，购物车，订单。

请帮我创建联接以显示数据.. .........

pls some one tell that how to create joins in multiple table in shopping cart database, my tables are product, category, cart, order.
Pls help me to create joins to show data...........

推荐答案

你需要了解SQL JOINS。



这里：

W3Schools：SQL Joins [ ^ ]

SQL教程 - SQL连接 [ ^ ]

CP：SQL加入 [ ^ ]

MSDN：加入基础知识 [ ^ ]

You need to read about SQL JOINS.

Here:
W3Schools: SQL Joins[^]
SQL Tutorial - SQL Joins[^]
CP: SQL Joins[^]
MSDN: Joins Fundamentals[^]

以下是两个很好的链接。和他们一起试试吧。如果您还有问题，请与我联系。



http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/ [ ^ ]



http://msdn.microsoft.com/en-us/library/ms191517（v = sql.90）.aspx [ ^ ]

Following are two good links to follow. Go through with them and try yourself. Then if you are still having issues, please contact me.

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]

http://msdn.microsoft.com/en-us/library/ms191517(v=sql.90).aspx[^]

这篇关于如何在sql server2005中的产品，类别，购物车，订单的购物车数据库表中进行连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！