That table doesn't have either of the columns bizState or bizCity.
With that definition, the query is going to give an Invalid column error because the two columns are not in the table.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability