union in a subquery

#1

Hello:

I need to perform following

select
col1
from
table1
where
col2
in
(select
cola
from
tablea
UNION
select
colb
from
tableb)

I can't do this - get error message

Server Message: Number 156, Severity 15
Server 'x', Line 24:
Incorrect syntax near the keyword 'UNION'.
Server Message: Number 102, Severity 15
Server 'x', Line 45:
Incorrect syntax near ')'.

#2

Is this with ASA or ASE? (Apparently from the latter.) Which release?

"Jean Legare" <jglegare (AT) hotmail (DOT) com> wrote

Quote:

Hello:

I need to perform following

select
col1
from
table1
where
col2
in
(select
cola
from
tablea
UNION
select
colb
from
tableb)

I can't do this - get error message

Server Message: Number 156, Severity 15
Server 'x', Line 24:
Incorrect syntax near the keyword 'UNION'.
Server Message: Number 102, Severity 15
Server 'x', Line 45:
Incorrect syntax near ')'.

#3

This was on ASE version 12.0.x

J

jglegare (AT) hotmail (DOT) com (Jean Legare) wrote in message news:<68e7005a.0406041243.cedf080 (AT) posting (DOT) google.com>...

Quote:

Hello:

I need to perform following

select
col1
from
table1
where
col2
in
(select
cola
from
tablea
UNION
select
colb
from
tableb)

I can't do this - get error message

Server Message: Number 156, Severity 15
Server 'x', Line 24:
Incorrect syntax near the keyword 'UNION'.
Server Message: Number 102, Severity 15
Server 'x', Line 45:
Incorrect syntax near ')'.

#4

try this, it should work.

(select
x=cola
from
tablea
UNION
select
x=colb
from
tableb)

jglegare (AT) hotmail (DOT) com (Jean Legare) wrote in message news:<68e7005a.0406041243.cedf080 (AT) posting (DOT) google.com>...

Quote:

Hello:

I need to perform following

select
col1
from
table1
where
col2
in
(select
cola
from
tablea
UNION
select
colb
from
tableb)

I can't do this - get error message

Server Message: Number 156, Severity 15
Server 'x', Line 24:
Incorrect syntax near the keyword 'UNION'.
Server Message: Number 102, Severity 15
Server 'x', Line 45:
Incorrect syntax near ')'.

#5

Try
select
col1
from
table1
where col2 in (select cola from tablea )
or col2 in (select colb from tableb)

"Jean Legare" <jglegare (AT) hotmail (DOT) com> wrote

Quote:

Hello:

I need to perform following

select
col1
from
table1
where
col2
in
(select
cola
from
tablea
UNION
select
colb
from
tableb)

I can't do this - get error message

Server Message: Number 156, Severity 15
Server 'x', Line 24:
Incorrect syntax near the keyword 'UNION'.
Server Message: Number 102, Severity 15
Server 'x', Line 45:
Incorrect syntax near ')'.

#6

In article <ca1o3v$qsb$1 (AT) lore (DOT) csc.com>, Willie Kraatz wrote:

Quote:

Try
select
col1
from
table1
where col2 in (select cola from tablea )
or col2 in (select colb from tableb)

In this solution sybase can't use indexes for col2. If the union does not
work it is at least possible to create temp. table with union and use
that in the in part.

Toni

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

union in a subquery

comp.databases.sybase comp.databases.sybase

union in a subquery - 06-04-2004 , 03:43 PM

Re: union in a subquery - 06-05-2004 , 06:34 AM

Re: union in a subquery - 06-05-2004 , 04:33 PM

Re: union in a subquery - 06-06-2004 , 04:01 PM

Re: union in a subquery - 06-07-2004 , 07:46 AM

Re: union in a subquery - 06-07-2004 , 01:23 PM