(Moderator)
Registriert seit: 9. Dez 2005
Ort: Heilbronn
39.858 Beiträge
Delphi 11 Alexandria
|
Re: multiple rows in singleton select
3. Mai 2006, 21:58
So sollte es gehen:
select * from dicentries where ((asterm like :asterm) and (asverw is null) and (zsverw is null)) or (id in (select asverw from dicentries where (asterm like :asterm))) order by asterm rows 20
Markus Kinzler
|