hallo, habe folgende query, welche nuter mysql prima funzt.
allerdings wirft er mir unter postgresql diese meldung: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
wo muss denn das order by sonst hin? in die select liste, aber wo? hab schon so ziemlich alles durch!?
vielen dank
Code:
SELECT DISTINCT b.id FROM baat b LEFT JOIN produsent p
ON (b.produsentid = p.id) LEFT JOIN baatutstyr bu
ON (b.id = bu.baatid) LEFT JOIN utstyr u
ON (u.id = bu.utstyrid) LEFT JOIN kategori k
ON (u.kategoriid = k.id) LEFT JOIN forhandlerbaat fb
ON (b.id = fb.baatid) LEFT JOIN forhandler f
ON (f.id = fb.forhandlerid) LEFT JOIN importorbaat ib
ON (b.id = ib.baatid) LEFT JOIN importor i
ON (i.id = ib.importorid) WHERE b.modell LIKE '%day%' OR b.produksjonsland LIKE '%day%'
OR b.lang_beskrivelse LIKE '%day%'
OR b.kort_beskrivelse LIKE '%day%' OR b.ovrige_opplysninger LIKE '%day%' OR b.byggemateriale LIKE '%day%' OR b.baattype LIKE '%day%' OR p.pnavn LIKE '%day%'
OR k.knavn LIKE '%day%' OR f.fnavn LIKE '%day%' OR i.inavn LIKE '%day%' ORDER BY p.pnavn ASC;
allerdings wirft er mir unter postgresql diese meldung: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
wo muss denn das order by sonst hin? in die select liste, aber wo? hab schon so ziemlich alles durch!?
vielen dank