The word "owner" is a MS SQL specific term (afaik) for what is known
as a "schema" in RDBMS lingo. With SQL Server it makes sense because I
believe the schemas in SQL are all tied directly to a user(name), so
that user would be the table's "owner", although I don't think this is
a requirement with all databases. In any event, because a given
database might have several of the same table with different schemas
(or owners), it's necessary to include the schema in the middle of the
string that identifies your table between the database name and the
table name. (In other words, the database might contain db.dbo.mytable
as well as db.larry.mytable, so you have to tell SQL Server whether
you want larry's or the dbo's table.)
hth
s. isaac dealey 214.823.9345
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
> I need to write a join that calls to tables in different
> databases.
> I created a user that can access both databases. I then
> created the
> datasource in CF and it points to the DB that will be hit
> the most. I
> then wrote the query
> select a.*, b.*
> from
> db.tablea a
> inner join
> db.tableb b
> Beside the fact that the join is not valid, I get an error
> "Invalid
> object name". Any suggestions?
> --
> Phillip B.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
