Re: SQL Question

From: Matt Brennan <mbrennan_at_gers.com>
Date: Mon, 27 Apr 1998 20:19:29 GMT
Message-ID: <01bd7219$f3a0ea40$049a0580@mcb>

D'OH! Left out a right parenthesis the first time around...

> select colA, colB
> from tablename 1
> where colC in(select max(colC) from tablename 2
> where nvl(2.colA,'X')||nvl(2.colB,'X')=nvl(1.colA,'X')||nvl(1.colB,'X')
> group by colA)

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com Received on Mon Apr 27 1998 - 15:19:29 CDT