subquery doesn't work

[chand012]

Three tables: tblA, tblB, tblC
Indexes:
tblA(colA) - unique
tblB(colB) - unique
tblC(colA, colB) - unique
tblC(colB) - normal

This query works:
"select * from tblA where colA not in (select colA from tblC where colB = $colB)"

This on doesn't:
"select * from tblB where colB not in (select colB from tblC where colA = $colA)"

Why?

[John]

Which version of Texis are you using?

In what way does it not work?

Are all the cols the same type? What types are they?

[chand012]

Texis version: Commercial Version 3.01.959738425 of May 30, 2000 (sparc-sun-solaris2.5.1)

The query doesn't work in that when the subquery returns no rows (as expected), the main query returns no rows instead of all rows.

Data types:
colA - varchar (both tables)
colB - counter (both tables)

[John]

You should have a newer distribution which solves the problem. If you have questions about which versions you should have please use the form at http://www.thunderstone.com/texis/site/ ... pport.html and supply your disk registration number.