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'
Last Wiki Answer Submitted: October 29, 2007 3:12 pm by Tudz Drkl0 pts.