peter pilsl <pilsl@xxxxxxxxxxxx> writes: > But there is a problem now: There are also entries in fn_kat which dont > have corresponding entries in fn_dokumente and this entries should be > listed too. With the proper count=0 !! > How to achieve this? LEFT JOIN before the group by? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq