>Whats wrong with this syntax:
>
>

>select document.* , station.station_name
>	from document, station
>	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.

select document.* , station.station_name
	from document join station
	ON station.id = document.station 

What type of data do you want to display? There are several join conditions that can be used.

Tom