sample107.sql

T-SQL示例大全

/* 文件名称: Sample107.sql */
USE 北风贸易

SELECT 客户.公司名称,订货主档.*
  FROM 客户 INNER JOIN 订货主档
       ON 客户.客户编号 = 订货主档.客户编号
  WHERE 订货主档.订单日期 BETWEEN '08/01/1996' AND '08/31/1996'