Column count doesn't match value count at row 1

[tollbooth]

I'm fairly new to Mysql and am trying to execute the following command:

insert into mhmissing(transid, recordid, clearingfirm, account, putcall, symbol, expiryear, expirmonth, strikedollar, strikefrac, longshort, securitytype, tradeprice, netposition, cusip, recordtype, tradesymbol, expirday, decimalstrike, spc, exectime, execdate, tagnumber, optiontype, contractyear, contractmonth)
select * from mhimports,mhini where mhimports.symbol = "" && mhimports.tradesymbol != mhini.original_sym

and am receiving the above error. These are all of the values located in the table. Any help??

 

[sleipnir214]

By my count, you are inserting data into 26 columns in mhmissing.

How many columns total do mhimports and mhini have together? It's probably not 26. ______________________________________________________________________
TANSTAAFL!

 

[tollbooth]

Thanks! Got it.