Difference between revisions of "Read tables from another schema/database"

From SQLZOO
Jump to: navigation, search
 
Line 16: Line 16:
 
</source>
 
</source>
 
<source lang='sql' class='def e-oracle'>SELECT COUNT(*) FROM haggis.tat
 
<source lang='sql' class='def e-oracle'>SELECT COUNT(*) FROM haggis.tat
 +
</source>
 
<source lang='sql' class='def e-sqlserver'>SELECT * FROM onedb.dbo.table1
 
<source lang='sql' class='def e-sqlserver'>SELECT * FROM onedb.dbo.table1
 
</source>
 
</source>

Latest revision as of 13:35, 17 July 2012

Read tables from another schema/database

schema:gisq

A particular server may support a number of different sets of tables. In Oracle these are schemas in MySQL they are databases. In both cases each user normally has their own set of tables, other users tables may be accessed using a dot notation.

 
 
 
 
 
Access does NOT do this kind OF thing.
NOT supported
SELECT COUNT(*) FROM haggis.tat
SELECT * FROM onedb.dbo.table1
SELECT * FROM gisq.one
 
 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense