摘要: 谁订购了产品,并且他们订购了什么产品?引用两个表View Code SELECT Persons.LastName, Persons.FirstName, Orders.OrderNoFROM Persons, OrdersWHERE Persons.Id_P = Orders.Id_P 结果集:LastNameFirstNameOrderNoAdamsJohn22456AdamsJohn24562CarterThomas77895CarterThomas44678SQL JOINView Code SELECT Persons.LastName, Persons.FirstName, Ord 阅读全文
posted @ 2012-10-18 10:03 jungil 阅读(150) 评论(0) 推荐(0) 编辑