SELECT
o.orderedon, o.name, o.partnum, o.quantity, o.res,
p.partnum, p.description, p.price
FROM orders o, part p WHERE o.partnum=p.partnum 这会出现一张表.
通过这张表.
你可以选择自己所要的排序方式.SELECT
o.orderedon, o.name, o.partnum, o.quantity, o.res,
p.partnum, p.description, p.price
FROM orders o, part p WHERE o.partnum=p.partnum
ORDER BY o.orderedon, o.name DESC最后去除你所不要的列SELECT
p.description, p.price
FROM orders o, part p WHERE o.partnum=p.partnum
ORDER BY o.orderedon, o.name DESC
o.orderedon, o.name, o.partnum, o.quantity, o.res,
p.partnum, p.description, p.price
FROM orders o, part p WHERE o.partnum=p.partnum 这会出现一张表.
通过这张表.
你可以选择自己所要的排序方式.SELECT
o.orderedon, o.name, o.partnum, o.quantity, o.res,
p.partnum, p.description, p.price
FROM orders o, part p WHERE o.partnum=p.partnum
ORDER BY o.orderedon, o.name DESC最后去除你所不要的列SELECT
p.description, p.price
FROM orders o, part p WHERE o.partnum=p.partnum
ORDER BY o.orderedon, o.name DESC
请看:mysql> select o.partnum,p.description,o.quantity*p.price due,o.name,o.partnum from orders o,part p where o.partnum=p.partnum;(这是我原来用的语句)
新语句如下:mysql> select o.partnum,p.description,o.quantity*p.price due,o.name,o.partnum from part p,orders o where o.partnum=p.partnum;