Re: joining 2 Tables.

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(at)yahoo(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>