Re: sql problem
| From: | Brett Bandy | Date: | Tue, 27 Mar 2001 02:25:04 +0000 |
| Subject: | Re: sql problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-45681@lists.php.net to get a copy of this message | ||
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"" <whalsey@btech.co.za> wrote in message
news:00a501c0b38b$e2a27ea0$256410ac@wadeh...
Hi ppl
("select empname from employer where empno = (select employercode from
badclient where pesal = '$Persal')")
Could anyone help me out with the syntax?
Im running an interbase db and php4.04
Thanks
Wade