On Mon, May 09, 2005 at 08:20:14AM -0700, David M. Cook wrote: > CREATE VIEW flat_recording_view as select r.recording_id, c.composer_name,
> SQL error: no such column: composer_name > > Aliasing the column names in the view using the 'as' syntax didn't help. I guess I mistyped my query, aliasing does work to clear up the problem. Also putting the column name in quotes as "c.composer_name" worked. Dave Cook