# 1168 Executing an SQL SELECT Query Containing a Sub-Select Causes an #15002 DBISAM_UNCOMPRESS Error

---

I get this error if I do the following in DBSYS 3.12 and server 3.12:

1. I run this Query:
Select * from prices where partno in
(Select PartNo from parts Where
(maingroup = 1 and category = 4 and subcategory = 3) or
(maingroup = 1 and category = 4 and subcategory = 4))

2. Now I try to open the Parts table.

On this open I get the error 15002. If I first unprepare the query statement, I don't get the error. It must be a problem with the subquery as this only happens if there is a subquery with the table I want then to open.