SELECT dbo.teststate.name
FROM dbo.teststate INNER JOIN
dbo.testcontent ON dbo.teststate.stateid = dbo.testcontent.stateid CROSS JOIN
dbo.testbaseinfo
WHERE (dbo.testcontent.testid = '8#070423')
FROM dbo.teststate INNER JOIN
dbo.testcontent ON dbo.teststate.stateid = dbo.testcontent.stateid CROSS JOIN
dbo.testbaseinfo
WHERE (dbo.testcontent.testid = '8#070423')
FROM dbo.teststate INNER JOIN
dbo.testcontent ON dbo.teststate.stateid = dbo.testcontent.stateid
WHERE (dbo.testcontent.testid = '8#070423')