Re: SQL dude

This is a good solution, but in this case don´t work :( The full query that i do:

SELECT lt.sale, lt.names, lt.id,
(SELECT spalte
FROM (SELECT spalte, COUNT (*) anz
FROM table_al al
WHERE al.m = lt.m /* <-- ERROR. lt.m invalid indentifier */ AND al.l = lt.l /* <-- ERROR. lt.l invalid indentifier */ GROUP BY spalte
ORDER BY anz DESC)
WHERE ROWNUM = 1) AS x
FROM table_lt lt

Con you help me? Thx
Regards,
Ruben Received on Fri Apr 07 2006 - 09:43:02 CDT