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.

--- "venumadhav g" wrote:
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"