Re: joining 2 Tables.
| От | Thomas Drebert |
|---|---|
| Тема | Re: joining 2 Tables. |
| Дата | |
| Msg-id | CANn+32jbdUn8+w_yO_wq9XN=WrUidSsRARSGJOekqa7V3jQ9-Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: joining 2 Tables. (David Johnston <polobo@yahoo.com>) |
| Ответы |
Re: joining 2 Tables.
|
| Список | pgsql-novice |
Hello,
if i use the *, I get an error message.
ERROR: column "n2.thecount" must appear in the GROUP BY clause or be used in an aggregate function
********** Fehler **********
ERROR: column "n2.thecount" must appear in the GROUP BY clause or be used in an aggregate function
SQL Status:42803
regarts
Thomas
2014-03-17 14:52 GMT+01:00 David Johnston <polobo@yahoo.com>:
Thomas Drebert wrote
> SELECT
> foo.updatezeit
> FROM
You joined them ok. But this says you only want to see the foo.updatezeit
in the final output. Try *
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/joining-2-Tables-tp5796290p5796328.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: