Click here to Skip to main content
14,300,703 members
Rate this:
Please Sign up or sign in to vote.
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...........
Posted
Comments
Amir Mahfoozi 5-Jan-13 8:02am
   
start SSMS -> click on New query -> right click in editor area -> select Design Query in Editor... : this wizard will help you to join tables and get the result.
Good Luck
Rate this:
Please Sign up or sign in to vote.

Solution 2

   
Comments
Espen Harlinn 6-Jan-13 9:23am
   
5'ed!
Sandeep Mewara 6-Jan-13 10:11am
   
Thanks. :)
Rate this:
Please Sign up or sign in to vote.

Solution 1

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[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100