摘要： A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of JOIN: INNER, OUTER, LEFT and RIGHT. As a special case, a table can JOIN to itself in a self-join.The following is the SQL to create two tables:CREATE TABLE department( Dep 阅读全文