Thread: SQL help needed
View Single Post
Old Nov 29, 2005 | 09:01 PM
  #2  
AKJ-Dan's Avatar
AKJ-Dan
Regular Contributor
 
Joined: May 2004
Posts: 308
Likes: 0
Default Re: SQL help needed
Originally Posted by J4son

I have JAN in FieldA and 05 in FieldB I want to populate FieldC with JAN05
INSERT INTO tbl_name (FieldC) VALUES(tbl_name.FieldA . tblname.FieldB) WHERE tbl_name.FieldA='JAN' AND tbl_name.FieldB='05';

What about that?
Reply
0