Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

newbie question warning

0 views
Skip to first unread message

yuriha

unread,
Oct 14, 2009, 11:48:27 AM10/14/09
to
Hi!

I'm new at Sybase, I want to make a query selecting fields from
different databases, how can I make it?

Thanks for your time!

Bret_Halford

unread,
Oct 14, 2009, 2:11:26 PM10/14/09
to

Sybase (the company) has 4 different database products (ASA, ASE, IQ,
Advantage),
so please specify the exact product, version and platform when you ask
a question.

Assuming you are asking about combining data from tables in
multiple databases on an Adaptive Server Enterprise server, you can
use fully qualified object names
(dbatabase_name.owner_name.table_name)

example:

select
a.col1, b.col2
from
table1..database1 a, table2..database2 b
where
a.pk = b.pk

yuriha

unread,
Oct 14, 2009, 2:30:43 PM10/14/09
to
it worked, thank you very much !

Carl Kayser

unread,
Oct 15, 2009, 8:49:57 AM10/15/09
to

"Bret_Halford" <br...@sybase.com> wrote in message
news:0f6ff31c-2b2a-4cd1...@k26g2000vbp.googlegroups.com...

On Oct 14, 9:48 am, yuriha <yur...@gmail.com> wrote:
> Hi!
>
> I'm new at Sybase, I want to make a query selecting fields from
> different databases, how can I make it?
>
> Thanks for your time!

(SNIP)

Assuming you are asking about combining data from tables in
multiple databases on an Adaptive Server Enterprise server, you can
use fully qualified object names
(dbatabase_name.owner_name.table_name)

example:

select
a.col1, b.col2
from
table1..database1 a, table2..database2 b
where
a.pk = b.pk


Bret obviously meant:

from
database1..table1 a, database2..table2 b (also ".." = ".dbo.")


0 new messages