InterBase isn't real good with subselects.
Try using a join instead:
select e.empname from employer e join badclient b on e.empno =
b.employercode where b.pesal = '$Persal';
Brett
""Wade Halsey"" <[EMAIL PROTECTED]> wrote in message
00a501c0b38b$e2a27ea0$256410ac@wadeh">news:00a501c0b38b$e2a27
Not sure what you are trying to do?
Not sure what a Persal is (maybe an Arial?)
Perhaps you want:
select
E.empname
from employer E, badclient B
where E.employercode = B.employercode
and E.pesal='$Persal'
Note there are two tables given aliases of E and B
that are JOINED by the first c
2 matches
Mail list logo
