Versions Compared

Old Version 3

changes.mady.by.user Saumya Sunder (Inactive)

Saved on

compared with

New Version Current

changes.mady.by.user Nisha Shantilal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

The SQL macros make it possible

Include Page
SUPPORT:How to combine queries from multiple databases
and data sources by using embedded SQL macros. This is a very powerful technique to integrate diverse data into a single view for data consumers. This makes for limitless opportunities based on using crafty SQL. In some cases, it can be tricky, but the results are worth it.

The technique is exactly the same as in /wiki/spaces/SQL/pages/74323667 with the only difference being the data source you choose on each of the inner queries.

74322248

Image Removed

SUPPORT:How to combine queries from multiple databases