| Subject | Re: [firebird-support] how to compare a value who comes from sub-select ref/eDN3012773479 |
|---|---|
| Author | Anderson Farias |
| Post date | 2007-07-27T16:14Z |
Hi,
I think you'd have to redeclare the select, like:
select a.*, (select somefield from sp) as somealias from table a
where (select somefield from sp)=somevalue
Regards,
Anderson
> Is there any way in where statement to get the value by column like DelphiAFAIK, no.
> expression: field[2].value ?
I think you'd have to redeclare the select, like:
select a.*, (select somefield from sp) as somealias from table a
where (select somefield from sp)=somevalue
Regards,
Anderson