 |
|
| Computers Forum Index » Computer - Databases - Sybase » newbie question warning... |
|
Page 1 of 1 |
|
| Author |
Message |
| yuriha... |
 Posted: Wed Oct 14, 2009 3:48 pm |
|
|
|
Guest
|
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! |
|
|
| Back to top |
|
|
|
| Bret_Halford... |
| Posted: Wed Oct 14, 2009 6:11 pm |
|
|
|
Guest
|
On Oct 14, 9:48 am, yuriha <yur... at (no spam) gmail.com> wrote:
Quote: 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!
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 |
|
|
| Back to top |
|
|
|
| yuriha... |
| Posted: Wed Oct 14, 2009 6:30 pm |
|
|
|
Guest
|
it worked, thank you very much !
On Oct 14, 1:11 pm, Bret_Halford <b... at (no spam) sybase.com> wrote:
Quote: On Oct 14, 9:48 am, yuriha <yur... at (no spam) 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!
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 |
|
|
| Back to top |
|
|
|
| Carl Kayser... |
| Posted: Thu Oct 15, 2009 4:49 pm |
|
|
|
Guest
|
"Bret_Halford" <bret at (no spam) sybase.com> wrote in message
news:0f6ff31c-2b2a-4cd1-82ad-c05b565e5fae at (no spam) k26g2000vbp.googlegroups.com...
On Oct 14, 9:48 am, yuriha <yur... at (no spam) gmail.com> wrote:
Quote: 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.") |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Nov 24, 2009 7:03 pm
|
|