I have now tried the following statement:
SELECT annoncer.id,MAX(annoncer.type) AS maks,annoncer.virk_id FROM
annoncer,virksomheder
WHERE virksomheder.navn LIKE '%SomeWord%' AND virksomheder.id =
annoncer.virk_id
GROUP BY annoncer.virk_id ORDER BY virksomheder.navn
This almost works...
forget the
> Or can a SQL statement do this in a DISTINCT like way? (SELECT
> table.id FROM table WHERE somthing is = somthing else and a lot of
> other stuff BUT only give me those where table.type has the hifgrst
> value)?
>
> Please... need help with this
> ~ Aidal.
SELECT t1.id
FROM TABLENAME t1
WHERE t1
