how to do joins in shopping cart database tables of product, category, cart, order in sql server2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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 5-Jan-13 1:12am

chander_rani

Add a Solution

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

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sandeep Mewara · Answer 1 · 2013-01-06T02:32:00

Solution 2

You need to read about SQL JOINS.

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

Posted 6-Jan-13 2:32am

Sandeep Mewara

Comments

Espen Harlinn 6-Jan-13 9:23am

5'ed!

Sandeep Mewara 6-Jan-13 10:11am

Thanks. :)

Tharaka MTR · Answer 2 · 2013-01-06T02:10:00

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