Incorrect syntax near ','.

[PRODIKEY]

I wanna to try BULK Insert from NEW_TUTOR to TUTOR and below are my sql statement :

CREATE Table TUTOR(
TutorName	varChar(100)	NOT NULL,
TutorContact	Numeric(8)	NOT NULL,
TutorAddress	Text		NULL,
Qualification	varChar(10)	NULL DEFAULT 'Degree',
CONSTRAINT	TutorNamePK	PRIMARY KEY(TutorName)
);

CREATE Table NEW_TUTOR(
TutorName	varChar(100)	NOT NULL,
TutorContact	Numeric(8)	NOT NULL,
Qualification	varChar(10)	NULL DEFAULT 'Degree',
CONSTRAINT  NewTutorNamePK  PRIMARY KEY(TutorName)
);

Insert into NEW_TUTOR(TutorName,TutorContact,Qualification)
	values('John',56433227,'‘A’Level);
Insert into NEW_TUTOR(TutorName,TutorContact,Qualification)
	values('Min Shen',65768765,'‘O’Level');
Insert into NEW_TUTOR(TutorName,TutorContact,Qualification)
	values('Micheal',65678989,'‘A’Level');

INSERT INTO TUTOR(TutorName,TutorContact,Qualification) 
SELECT (TutorName,TutorContact,Qualification)

FROM NEW_TUTOR;

When I execute the BULK Insert, the SQL SERVER prompted me
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ','.


Any suggestion how to over come this.

[ck9663]

Check out the value's you're inserting to Qualification column. What's with '‘ ??

~~ CK

[PRODIKEY]

Thanks I found my mistake..

INSERT INTO TUTOR(TutorName ,TutorContact,Q ualification)
SELECT TutorName,Tutor Contact,Qualifi cation
FROM NEW_TUTOR;

*Remove the () under select statement