有时为了得到完整的结果,我们需要从两张或多张表中查询数据。这时我们就需要用join。
例:
select Persons.lastName,Persons.FirstName,Orders.OrderNo from Persons inner join Orders on Persons.Id_p = Orders.Id_p order by Persons.lastName
例:
select Persons.lastName,Persons.FirstName,Orders.OrderNo from Persons inner join Orders on Persons.Id_p = Orders.Id_p order by Persons.lastName