6.sql

来自「vb。net 2003数据库设计整套源代码」· SQL 代码 · 共 6 行

select aname,price*anount total
           from accessory,store
           where store.ano=accessory.ano 
            and sno=012
            order by price*anount