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 391,824 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 3,711 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:

Extract columns from two independent table in SQL Server 2005?

•

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,