[SQL] query two tables with relation one-to-many

ORDERBY
http://www.1keydata.com/tw/sql/sqlorderby.htm
l
JOIN
http://www.1keydata.com/tw/sql/sqljoins.html

WHERE
http://www.fooish.com/sql/where.html

]query two tables with relation one-to-many
https://stackoverflow.com/questions/9420475/sql-query-two-tables-with-relation-one-to-many