how can i join three or more tables

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008

How can i join three tables(a,b,c). They all have different num of coloums but three coloums(i.e name,fname,class) are same in all tables.
plzz tell me...!!

Posted 24-Oct-13 8:15am

Member 10279752

Add a Solution

Comments

Ranjan.D 24-Oct-13 14:18pm

Join tables based on their primary key. You did not even said what type of join. Have a look into - http://www.w3schools.com/sql/sql_join_inner.asp

Member 10279752 24-Oct-13 14:25pm

i didn't declaired any primary key.But in all tables i also have three same coloum name. in all tables. on the base of these three same coloums i wants to fire search query for further operation.

2 solutions

Add a Solution

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

Ranjan.D · Answer 1 · 2013-10-24T08:30:00

Solution 1

Have a look into

http://forums.asp.net/t/1756001.aspx[^]

Posted 24-Oct-13 8:30am

Ranjan.D

Abhinav S · Answer 2 · 2013-10-24T08:36:00

Solution 2

Try Joining Three or More Tables[^].

Posted 24-Oct-13 8:36am

Abhinav S

how can i join three or more tables

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how can i join three or more tables

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us