同求一条sql

[zecool20]

create table x(
id tinyint(5) unsigned not null auto_increment,
name char(25) not null default '',
price DECIMAL(4,2) unsigned not null default '0',
primary key(id),
unique key name(name)
)engine=myisam default charset=utf8
insert into x(id,name,price)values(null,'冰红茶',3.5);
insert into x(id,name,price)values(null,'电饭锅',99);
create table y(
id tinyint(5) unsigned not null auto_increment,
individual tinyint(5) unsigned not null,
primary key(id)
)engine=myisam default charset=utf8
insert into y(id,individual)values(null,4);
insert into y(id,individual)values(null,2);


查询输出结果要这样:212 = 14+198

[ACMAIN_CHM]

select sum(x.price*y.individual)
from x,y
where x.id=y.id

[zecool20]

结果还是不对，还差一点点。。。
+---------------------------------------------------------------------------------------------+
| concat(sum(x.price*y.individual),'=',x.price,'*',y.individual,'+',x.price,'*',y.individual) |
+---------------------------------------------------------------------------------------------+
| 212.00=3.50*4+3.50*4 |
+---------------------------------------------------------------------------------------------+