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
Similarities / differences b/w Access and SQL Server Express 7
VS2008 - different ways to work with MS SQL Server database 1
Please help me evolve this concept 2
Default DataTable Constraints with SQL Server 2000 vs 2005 4
Fatal errors with SQL 2005 5
cross database linq 0
Calling SQL from code has different behaviour than calling it from MS SQL Server Management Studio 1

Top