MS SQL Server Joins Concept

V

venumadhav g

Hi Folks,
I am useing SQL Server 2005. I want to join two different tables data from
two different Databases(Ex: 1. Database_X 2. Database_Y). Both Available
DBs having one common field..field_A

Can I have the Query for the above..?

dbname1:Database_X:
Tablename- OneTable
FieldsNames: A B C D
dbname2:Database_Y:
Tablename- TwoTable
FieldsNames: A M N O


How to take out put as " A B C M N"

:please reply ASAP
 
B

Bob Bridges

Seems to me you want to post this on some other forum -- the Access form,
maybe, though I don't spend much time there and am not sure. This is Excel
formulae, which is why you didn't get any response right away.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL SERVER JOINS CONCEPT: 3
OpenDataSource SQL Server xpress problem 6
Sql Server and Un-Bound Forms 2
Similarities / differences b/w Access and SQL Server Express 7
Fatal errors with SQL 2005 5
adp Connection to SQL Server 2
DOWNLOAD GibbsCAM 2009,Autocad 2009,WILCOM 2009,CAMWORKS 2009,CATIA2009,Medical software,MASTERCAM X 0

Top