Loading

how to get the columns from multiple tables into a single qu

Anjali C

I m doing a online shopping website and in dat I want a page dat fetches the order history of a customer but problem is the order table do not contain customer id and i want the customer id should be selected from customers table should I use nested query...plz any suggestion?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Harpreet Singh11y ago
To get the columns from multiple tables you can use JOINS
http://www.c-sharpcorner.com/UploadFile/219d4d/joins-in-sql-server/
Pankaj Kumar Choudhary11y ago
If i got it right You want to get the columns from multiple tables into a single query.
for this you can use this method

select Table1.Col,Table2.Col, Table2.Col from Table1 cross join Table2

if i am wrong then Please you can clarify what type of O/P you require......