name NAZIV_KOLONE is ambigous

[ tokajac @ 22.08.2008. 14:10 ] @

Radim sa AS400 bazom na upitu:

Code:

        SELECT   *
        FROM
        (
             SELECT * FROM
            BFWBBBKS b
            left outer join BFWBBCLS c on b.COLID=c.COLID
            left outer join BFWBBCLA ca on ca.COLADRID=b.COLADRID
            left outer join BFWBBCTP ct on ct.CARTPID = b.CARTPID
            left outer join BFWBBCAR car on car.CARID =b.CARID
            left outer join BFWBBSTS bs on bs.BOOKSTSID = b.BOOKSTSID
            left outer join BFWBBUSR cu on CAST(b.CRTUSRID AS INTEGER) = cu.WBBUSERID
                  left outer join BFWBBUSR uu on CAST(b.UPDBUSRID AS INTEGER) = uu.WBBUSERID
            order by b.WBBBOOKID
            FETCH FIRST 20 ROWS ONLY
        ) AS bo
                order by WBBBOOKID desc
        FETCH FIRST 20 ROWS ONLY

sve OK.

Ono sto hocu, je da izvucem samo pojedine kolone iz upita, ali se javlja greska ukoliko kolonu sadrzi vise od jedne tabele
NAME naziv_kolone IS AMBIGOUS
Na primer:

Code:

        SELECT  COLID
        FROM
        (
             SELECT * FROM
            BFWBBBKS b
            left outer join BFWBBCLS c on b.COLID=c.COLID
            left outer join BFWBBCLA ca on ca.COLADRID=b.COLADRID
            left outer join BFWBBCTP ct on ct.CARTPID = b.CARTPID
            left outer join BFWBBCAR car on car.CARID =b.CARID
            left outer join BFWBBSTS bs on bs.BOOKSTSID = b.BOOKSTSID
            left outer join BFWBBUSR cu on CAST(b.CRTUSRID AS INTEGER) = cu.WBBUSERID
                  left outer join BFWBBUSR uu on CAST(b.UPDBUSRID AS INTEGER) = uu.WBBUSERID
            order by b.WBBBOOKID
            FETCH FIRST 20 ROWS ONLY
        ) AS bo
                order by WBBBOOKID desc
        FETCH FIRST 20 ROWS ONLY

Kako da izvucem samo odredjene kolone?

Pozdrav

P.S.
probao sam sa b.COLID