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
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
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