I am getting a syntax error at or near 'as' in this method, can anyone
help?
create table iclasses
(classid serial,
subject text,
year text,
groups text,
teacher text,
set text
)
as select distinct subject,year,groups,teacher,set from interimclasses
I need to make a new table with a classid. Any comments are more than
welcome.
regards
garry