Difference between revisions of "Read tables from another schema/database"
From SQLZOO
(Created page with "Read tables from another schema/database <div class='ht'> <div class=params>schema:gisq</div> <div> A particular server may support a number of different sets of tables. In Or...") |
|||
| Line 18: | Line 18: | ||
<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> | ||
| − | <source lang='sql' class='def e-mysql'>SELECT * FROM | + | <source lang='sql' class='def e-mysql'>SELECT * FROM gisq.one |
</source> | </source> | ||
<source lang='sql' class='def e-mimer'></source> | <source lang='sql' class='def e-mimer'></source> | ||
Revision as of 13:12, 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 supportedSELECT COUNT(*) FROM haggis.tat <SOURCE lang='sql' class='def e-sqlserver'>SELECT * FROM onedb.dbo.table1
SELECT * FROM gisq.one
Read tables from another schema/database
