Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Nov 17, 2001

Getting Information from MSAccess and SQLServer with One Single QUERY(T-SQL)


The ProductMaster Table is in MSAccess and the productdescription Table is in SQLServer. Create the Example.mdb in C drive and Create the Below table in MDB(MSAccess).
 
ProductMaster(MSAccess)
-----------------------
pid	ProductName

1	maruthi
2	MercedesBenz
3	HondaCity
4	OpelAstra



productdescription(SQLServer)

pid         Prize
----------- -----------
1           160000$
2           200000$
3           300000$

To get the pid,prodcutname,prize from these two tables, execute this SQL(t-sql):
 
select b.pid,b.ProductName,a.prize from 
productdescription a inner join
(SELECT pid,ProductName  FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0',_
'c:\example.mdb';'admin';'',[productm
aster])) as b on
a.pid=b.pid

Result
-----------

pid         pname                                              
prize
----------- ---------------------------------------- 
-----------

1           maruthi                                            
160000
2           MercedesBenz                                       
200000
3           HondaCity                                          
300000
Srinivas Reddy
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date