Problem with sql views.

[Energize]

create or replace view view_d_songs (id, song title, artist) as
select id, title, artist
from d_songs
where type_code = 'New Age'

Can anyone tell me why this doesn't work?

It will execute fine when I don't use aliases.

 

[Energize]

Anyone?

 

[JIMA]

Have you got a space in the "songtitle" attribute in the first part of the SQL? Could be a typo in the mail, can't see anything else obviously wrong though.

Jim