Hi folks,
I don;t know if it's cos it's Monday or what, but I can't see what's wrong
here.
I've got two tables, turns which holds a turn number, a task, and where
appropriate a link to a loco. The select below works but only shows those
tasks where a loco is involved.:
select r.rtid, concat(
On Mon, 11 Aug 2003, Gary Stainburn wrote:
> I don;t know if it's cos it's Monday or what, but I can't see what's wrong
> here.
>
> I've got two tables, turns which holds a turn number, a task, and where
> appropriate a link to a loco. The select below works but only shows those
> tasks where a l
Hi folks,
I don;t know if it's cos it's Monday or what, but I can't see what's wrong
here.
I've got two tables, turns which holds a turn number, a task, and where
appropriate a link to a loco. The select below works but only shows those
tasks where a loco is involved.:
select r.rtid, con
>
> select r.rtid, concat(r.rcid::text || ' on ' || l.lnumber::text) as
task
> from rides r, loco_dets l where r.rlid = l.lid group by rtid;
>
Looks like another implicit FROM clause mystery.
Try
... GROUP BY r.rtid ;
The same goes for the JOIN.
Regards, Christoph
--
On Monday 11 August 2003 11:24 am, Gary Stainburn wrote:
> Hi folks,
>
> I don;t know if it's cos it's Monday or what, but I can't see what's wrong
> here.
>
> I've got two tables, turns which holds a turn number, a task, and where
> appropriate a link to a loco. The select below works but only sh
