16 Mar 2007 at 22:04 #1 Energize Energize Caporegime Joined 12 Mar 2004 Posts 29,962 Location England 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.
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.
16 Mar 2007 at 23:46 #2 Energize Energize Caporegime OP Joined 12 Mar 2004 Posts 29,962 Location England Anyone?
