Extract columns from two independent table in SQL Server 2005?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 361,942 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,677 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 847 | Replies: 5

•

Join Date: Sep 2006

Posts: 104

Reputation: bhavna_816 is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

bhavna_816 bhavna_816 is offline

Offline

Junior Poster

Extract columns from two independent table in SQL Server 2005?

Apr 11th, 2008

I want to get two columns data from two tables which are not dependent to each other i.e. no key common in both they are not related to each other.

I can't use JOIN because it needs where clause which uses a common field from both tables.
I just want one column from one table and one column from another and display it.
how can do it?
some unions or any other syntax for that?

Thanks in advance,

•

Join Date: Aug 2005

Location: Ohio

Posts: 204

Reputation: plazmo is an unknown quantity at this point

Rep Power: 3

Solved Threads: 16

plazmo

Offline

Posting Whiz in Training

Re: Extract columns from two independent table in SQL Server 2005?

Apr 11th, 2008

select * from table1, table2

this combines both tables

•

Join Date: Mar 2008

Posts: 115

Reputation: sonia sardana is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

sonia sardana sonia sardana is offline

Offline

Junior Poster

Re: Extract columns from two independent table in SQL Server 2005?

Apr 11th, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE name1(name varchar)
INSERT INTO name1 VALUES('A')
INSERT INTO name1 VALUES('B')
 
CREATE TABLE name2(name varchar)
INSERT INTO name2 VALUES('B')
INSERT INTO name2 VALUES('C')
 
SELECT name FROM name1
UNION
SELECT name FROM name2
create table name1(name varchar)
insert into name1 values('A')
insert into name1 values('B')

create table name2(name varchar)
insert into name2 values('B')
insert into name2 values('C')

select name from name1
UNION
select name from name2

UNION will eliminate duplicates,If u want to retain duplicates Use UNION ALL.

Is that worked for u?If face any probs reply.

Last edited by peter_budo : Apr 11th, 2008 at 6:47 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Mar 2008

Posts: 115

Reputation: sonia sardana is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

sonia sardana sonia sardana is offline

Offline

Junior Poster

Re: Extract columns from two independent table in SQL Server 2005?

Apr 12th, 2008

Can u Paste the tables & specify which column to retrieve, so that I can help u out.

•

Join Date: Apr 2008

Posts: 4

Reputation: aardvax01 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

aardvax01

Offline

Newbie Poster

Re: Extract columns from two independent table in SQL Server 2005?

Apr 14th, 2008

Hi Bhavna

I think that you can do it yourself
There is something called Non -Equi Joins Which needs the where clause which you want
I think you can use Logical Operators to accomplish what you want

There is one Example of Employee and Salary Tables ( a famous one)

Hope this will help you

Ok lemme give an Example -- Suppose there are two tables with name as Emp and Salary

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT E.Last_Name, E.Sal, S.Category
FROM Emp E, Salary S
WHERE E.Sal BETWEEN S.Highest AND S.Lowest
SELECT E.Last_Name, E.Sal, S.Category
FROM Emp E, Salary S
WHERE E.Sal Between S.Highest and S.Lowest

And this example is taking oracle in consideration ..
there might be some other way of using joins in SQL Server
I will have a look and will edit this post once more

Last edited by peter_budo : Apr 17th, 2008 at 1:53 pm. Reason: Keep It Organized - please use [code] tags