.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Selecting Two Tables

Posted By: Dhilip.R     Posted Date: November 30, 2010    Points:2   Category :Sql Server
I have to SELECT two tables which are not having any relation in a single query itself


Thanks & Regards
Dhilip.R

Responses
Author: Dhivakaran             
Posted Date: November 30, 2010     Points: 5   

Hi Dhilip

Pls descrip in detail.

-
Dhivakaran T
Author: Sajid P K             
Posted Date: November 30, 2010     Points: 5   

Hi Dhilip

you can use follwing query

SELECT * FROM TABLE1 ,TABLE2


Regards,
Sajid P k

Author: SureshM             
Posted Date: December 03, 2010     Points: 5   

Hi

If u Use this query

SELECT * FROM TABLE1 ,TABLE2

If Table1 having 50 rows and Table2 having 20 rows

How many rows will have the result set ?


Author: Vijay             
Posted Date: January 21, 2011     Points: 5   

HI Suresh,

It will display 1000 rows...

Thanks,
Vijay

Author: Narayanan             
Posted Date: July 13, 2011     Points: 20   

Hi,
create view and Select from viewname


Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author: Ravi Ranjan Kumar             
Posted Date: July 17, 2011     Points: 20   

hey! you already got many answer before I did. I've written an article based on same concept in which user can take value of two table and then merge it in dataset and after that dataset will responsible to give total number of rows and column together.
Take a look
http://www.dotnetspark.com/kb/4214-merging-data-within-datasets.aspx

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend