Remove ',station' from FROM because it's in JOIN.
>Whats wrong with this syntax:
>
>
>select document.* , station.station_name
> join station on document.station = station.id
>
>
>I'm getting the message:
>The objects "station" and "station" in the FROM clause have the same exposed names.
>Use correlation names to distinguish them.
--sb--