ldg1976 Posted January 31, 2008 Share Posted January 31, 2008 I have 2 tables (info and category) where I need to add a refernece number from the info table into the category table (info has a cat_id field to populate the same field in the category table), but no luck so far! Any ideas out there?Thank you Link to comment Share on other sites More sharing options...
justsomeguy Posted January 31, 2008 Share Posted January 31, 2008 INSERT INTO category (cat_id) VALUES (1)like that? or..INSERT INTO category (cat_id) SELECT cat_id FROM info Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.