> SELECT COUNT(query2.*),
> query1.all_kod,quey1.nev,query1.megall,query1.erkezik_ido,query1.indul_ido,'910_'
> || COUNT(query2.*)
> FROM (/*your query goes here */) query1, (/*and here */) query2
> WHERE query1.indul_ido >= query2.indul_ido
Here is my SELECT first:
SELECT sorszam, all_kod, nev, megall, erkezik_ido, indul_ido, train_selector
FROM menetrend, stat where statkod=all_kod and
train_selector in (SELECT train_selector
FROM service where vonatszam='910' and datum_ig>now() and
datum_tol<now() order by datum_ig desc, datum_tol desc) order by
indul_ido
When I run that I got what I put here.
After this I combined your version with my select:
( I put my SELECT mechanically twice in /*your query goes here */ parts.)
SELECT COUNT(query2.*),
query1.all_kod,query1.nev,query1.megall,query1.erkezik_ido,query1.indul_ido,'910_'
|| COUNT(query2.*)
FROM (SELECT sorszam, all_kod, nev, megall, erkezik_ido, indul_ido,
train_selector
FROM menetrend, stat where statkod=all_kod and
train_selector in (SELECT train_selector
FROM service where vonatszam='910' and datum_ig>now() and
datum_tol<now() order by datum_ig desc, datum_tol desc) order by
indul_ido) query1, (SELECT sorszam, all_kod, nev, megall, erkezik_ido,
indul_ido, train_selector
FROM menetrend, stat where statkod=all_kod and
train_selector in (SELECT train_selector
FROM service where vonatszam='910' and datum_ig>now() and
datum_tol<now() order by datum_ig desc, datum_tol desc) order by
indul_ido) query2
WHERE query1.indul_ido >= query2.indul_ido
The result is:
ERROR: column "query1.all_kod" must appear in the GROUP BY clause or
be used in an aggregate function
In my SELECT only one train was selected.
TIA,
Ruzsi