ldg1976 Posted January 31, 2008 Report 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 Report 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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now