I am in need of hooking two databases together, same server. The fields for this report are all in one table but the prompts are in a different table, different database. How do i join them??

Question

question

hobbsa asked Mar 21, '16

I am in need of hooking two databases together, same server. The fields for this report are all in one table but the prompts are in a different table, different database. How do i join them??

sql database join

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sjimmo commented · Mar 21, 2016 at 03:27 PM

Can you please go into more detail about what you are trying to do? Can you also provide table schemas and tell us what you have tried so far?

0 ·

Answer 1 · 2016-03-21T16:12:48Z

ThomasRushton answered Mar 21, '16

You could try using three-part naming convention? When you write your SELECT statements, reference the objects in three parts - databasename, schemaname, objectname. eg: SELECT * FROM ReportFields.dbo.FieldsTable LEFT JOIN ReportPrompts.dbo.PromptTable ON ... Without more detail, it's hard to know what else to suggest.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question