whats wrong with this mysql insert query?

insert into tblcustomermachine
(
 select * from
 ((select vch_CustomerID  from tblcustomer where tblcustomer.vch_CustomerID='Cust00001' )
 union all
 (s开发者_Python百科elect Rate  from tblmachine))  as t );

that table contains 18 cols and this resultset also contains 18 rows yet it shows " Column count doesn't match value count at row 1" . why?

---

It looks like your table tblcustomermachine has more then the 1 column.

Like Simone answered, update your insert to INSERT INTO tblcustomermachine(col_1) SELECT ...

You may skip the column names during INSERT, however the SELECT needs to return the same amount of columns that the table holds.

---

AFAIK, you have to declare field name:

insert into tblcustomermachine (col_1, col_2, col_3, ... col_18) (
   select t.field1, t.field2, t.field3, ... t.field18 from (
      (select vch_CustomerID from tblcustomer where tblcustomer.vch_CustomerID='Cust00001') 
       union all (select Rate from tblmachine))
   as t
   );