Re: Concat and view - Re: create view error

On Monday 07 Jul 2003 2:12 pm, Gary Stainburn wrote:
>
> I've managed to get the view I wanted by using sub-selects - as shown
> below, but I now have the 'lid' field showing in the resulting view three
> times (as lid, lnid and lnaid).  How can I remove lnid and lnaid from the
> result?
>
> create view loco_dets as
>   select * from locos l
>       left outer join
[snip]

Don't do "select *" do "select field_a,field_b..." - the * doesn't just refer
to the locos table.

--  Richard Huxton