db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Legolas Woodland <legola...@gmail.com>
Subject can you help me to solve a query problem which 3 tables are engaged in it?
Date Wed, 04 Jan 2006 00:11:32 GMT
Thank you for reading my post
I have 3 tables like the above images
a web sites , a category and a relation between them.
I defined a relation between web sites and categories in table 
website_categories
so if a web site incoperate in a category then its id with category id 
will be there

I want to return categories that an specefic web site in not in it.
:( i tried every combination of joins and where cluases but i never 
recieved correct categories.

can some one pleas help ?
Thank you


Mime
View raw message