SELECT dbo.smallClass.ClassName AS smallClassName, dbo.classList.className, dbo.classList.bigClassName, dbo.classList.id AS classID, dbo.smallClass.id AS smallID FROM dbo.classList INNER JOIN dbo.smallClass ON dbo.classList.className = dbo.smallClass.bigclassName WHRER dbo.smallClass.className='aa' and dbo.classList.className = 'bb'
select * from table where 1=1 and a=b and b=c and c=d 这只是个样板。。具体情况具体再写。
dbo.classList.bigClassName, dbo.classList.id AS classID,
dbo.smallClass.id AS smallID
FROM dbo.classList INNER JOIN
dbo.smallClass ON dbo.classList.className = dbo.smallClass.bigclassName
WHRER
dbo.smallClass.className='aa' and dbo.classList.className = 'bb'
这只是个样板。。具体情况具体再写。