db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject Problem with sql statement , can some one help me to get count of a complex select ?
Date Sun, 07 May 2006 22:35:42 GMT
Hi
Thank you for reading my post.
i really tried to get count of  rows that this statement return with no 
luck.


SELECT * FROM categories   WHERE categories.categoryid NOT IN
    ( SELECT DISTINCT categoriescategoryid 
    FROM BANNER_categories WHERE BANNERBANNERID = 10)

if we think this statement is A then i tried :
I tried :
select count(*) from (A)
select count(A)
select count(*) , A
....

but still i can not find this statement total returning rows.

Mime
View raw message