一个sql的例子

 SELECT dbo.UserInfo.UserName, dbo.UserInfo.UserTrueName,
      dbo.UserInfo.UserEmail, dbo.UserInfo.UserMobile, dbo.UserInfo.UserTelephone,
      dbo.UserInfo.userCar, dbo.UserCar.UserBHMCBrand, dbo.UserInfo.regDate,
      dbo.UserInfo.id
FROM dbo.UserInfo INNER JOIN
      dbo.UserCar ON dbo.UserInfo.id = dbo.UserCar.UserId
WHERE (dbo.UserInfo.userCar = '1') AND (dbo.UserInfo.regDate >= CONVERT(DATETIME,
      '2006-11-30 00:00:00', 102)) AND (dbo.UserInfo.regDate <= CONVERT(DATETIME,
      '2007-1-1 00:00:00', 102)) AND (dbo.UserCar.UserBHMCBrand = 6 OR
      dbo.UserCar.UserBHMCBrand = 7)
ORDER BY dbo.UserInfo.id DESC