hi,
1.I have created a view via this method
create view passport2
2. Then i created a new table called newpassport2 via:
Code
create table newpassport2
(skilltext char(50), passportid char(10), skilllevelid char(10), dateid char(11), active char(10), pctcompleted char(10))
And the above is fine....
but when i try to insert into the new table, newpassport2 via passport2, using:
Code
Insert into newpassport2 (skilltext char(50), passportid char(10), skilllevelid char(10), dateid char(11), active char(10), pctcompleted char(10))
SELECT
skilltext, passportID, SkillLevelID, CompletedAt, Active, PctCompleted
FROM
Passport2
it comes up with an error.......
Can someone help please.
Cheers
Jay