Subject | Re: [firebird-support] Weird query results - bug? |
---|---|
Author | Kjell Rilbe |
Post date | 2013-01-21T11:30:55Z |
Den 2013-01-21 11:24 skrev Gary Benade såhär:
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> One last try, what does this give you?Same 2533 records as usual. :-)
>
> select B.*
> from "Branschkod" B
> inner join "Branschkod" B2 on B2."Namn" = B."Namn" and B."ECO_ID" <> B2."ECO_ID"
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64