lmain
WHERE AND id NOT IN (SELECT id FROM tblcount);
However, thanks to off-list correspondence, I now know that I need to
do some research into temporary tables because these can provide most
(if not all) the functionality of sub-selects.
Thanks again to all,
--
Geoff Lane
Cor
sub-select.
The MySQL docs say that sub-selects are due for implementation in 4.x.
In the meantime, is there a way to emulate the preceding statement
that won't cause concurrency problems?
TIA,
--
Geoff Lane
Cornwall, UK
[EMAIL PROTECTED]
---
