SELECT dbo.sysobjects.name
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
Where dbo.syscolumns.name = 'ZA0101'
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
Where dbo.syscolumns.name = 'ZA0101'
and a.name= 'ZA0101'