Query for Cross Connections
Comments
-
Hello,
I was wondering if we can create a query SQL script from a certain connection and cross reference via SQL Alias to another connection DB for joining tables to view other table data elements? If so, how would we write out the SQL statement within the Query Editor so it will be compatible. Example: Connections: LOCAL CONNECTION (Investigators) , SQL_MyAppied (TeamMembers) I want to select on teammemberID via Inner Join between the 2 tables on different connections.
Thanks
-
Hi,
Joining two database tables can be done, but only when databases are on the same server. The only difference here is that you must fully specify table names.
The syntax for this query would look something like this:
[color=#3300ff]select[/color] *
[color=#3300ff]from[/color] LOCAL.dbo.Investigators c
[color=#3300ff]join[/color] SQL_MyAppied.dbo.TeamMembers m [color=#3300ff]on[/color] c.teammemberID = m.teammemberIDHope this helps!
Howdy, Stranger!
Categories
- 4.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 108 Rules
- 264 Administration
- 212 Portal
- 494 General Q & A
- 702 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 53 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 181 Datastructures
- 69 Repository
- 222 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 106 Lunch And Learn Questions