Re: DISTRINCT weiter eingrenzen
Torsten Egeler Wrote:
-------------------------------------------------------
> 1 Count-Abfage
>
> SELECT COUNT(DISTINCT medikamente.id) FROM
> `medikamente` LEFT JOIN `objekte` ON
> objekte.objekt_medikament_id = medikamente.id
> WHERE (medikamente.name LIKE '%Hund%') OR
> (objekte.objekt_suchtext LIKE '%Hund%')
>
> 2 Tatsächliche Abfrage um Daten zu holen
>
> SELECT DISTINCT medikamente.*, firmen.name1 AS
Wenn die Spalte medikamente.id eine eindeutige ID ist (PK der Tabelle medikamente), dann kann der DISTINCT nicht funktionieren, da er die Ergebnisspalten nicht weiter verdichten kann.
Grüße
Thomas
Subject
Views
Written By
Posted
1769
April 08, 2012 11:07AM
1037
April 08, 2012 11:25AM
974
April 08, 2012 11:52AM
1030
April 08, 2012 11:59AM
Re: DISTRINCT weiter eingrenzen
1432
April 08, 2012 12:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.