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