Update problem

I am having problems getting an update to work correctly. Assume that I have two tables, employee and office. Employee has two fields, employee_id and employee_name, and office has three fields, office_id, office_number, & employee_id. I have been using inner join to link the tables together

order by number

When doing a select with an order by clause, how do you make mysql list the items in correct numberical order. Normally, when I run the command mysql will list 1000 before 200 because of the initial digit. How do I correct this? Thanks, Phil Get 250 color business cards for FREE! http://bu

Re: Multiple Tables

I am overlooking something as for the code to update the user table. Maybe it would help to make it more concrete. Assume that I create two tables with the following statements: CREATE TABLE system ( sysid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, sysname VARCHAR(12), os VARCHAR(10), cpumhz INT