select * from zapr
where ident not in (select idvira from virm)

---

 Comments and Workarounds

---

Workaround is to not use RequestLive=True. The above sub-query should have made the query generate a canned result set, but it was not, and this was causing a problem with completing the query.

---

 Resolution

---

Fixed Problem on 10/12/2004 in version 4.13 build 1