RATE THIS ANSWER
0
Click to Vote:
0
0
Last Answered:
Oct 29 2007 3:12 PM GMT
by Tudz Drkl
Your target (custmaster) and source (tnjcust) must have the same number and types of columns when you construct an INSERT statement this way. Frankly, this construction is not a good programming practice. Instead you should list the columns:
INSERT INTO custmaster(x,y,z) SELECT seccode,b,c FROM tnjcust WHERE seccode='431'