相关的数据表 对 19 个字段操作
显示页面时显示的数据 存储过程
SELECT Customers.CustomerName'客户名称', CustomerTypes.CustomerTypeName'客户类型',
Cities.CityName'城市',Areas.AreaName'地区', Persons.PhoneNum'电话', Persons.FaxNum'传真'
FROM Customers INNER JOIN
CustomerTypes ON
Customers.CustomerTypeID = CustomerTypes.CustomerTypeID INNER JOIN
Persons ON Customers.PersonID = Persons.PersonID INNER JOIN
Cities ON Persons.CityID = Cities.CityID INNER JOIN
Areas ON Persons.AreaID = Areas.AreaID
where Customers.StateFlag>0
根据客户名查询
@m_name varchar(50)
AS
SELECT Customers.CustomerName'客户名称', CustomerTypes.CustomerTypeName'客户类型',
Cities.CityName'城市',
Areas.AreaName'地区', Persons.PhoneNum'电话', Persons.FaxNum'传真'
FROM Areas INNER JOIN Cities ON Areas.CityID = Cities.CityID INNER JOIN
Persons ON Areas.AreaID = Persons.AreaID inner JOIN
评论0