Re: SQL question

Guillermo Labatte wrote:
>
> Hi,
> I'm using online 5.07 and I have a little problem here. I need to submit a
> query like this:
>
> select * from tabA
> where
> tabA.colX||tabA.colY=(select max(tabB.colX||tabB.coly)
> from tabB where ....)

create temp table fred (
int rownum,
char colx(10),
char coly(10 );

insert into fred
select rowid, colx, coly
from tabA;

select a.*
from tabA a, fred f
where a.rowid = f.rownum
  and f.colx||f.coly= (select max(tabB.colX||tabB.coly)

                                         from tabB where ....);

Art S. Kagel Received on Mon May 11 1998 - 00:00:00 CEST