视图SQL【视图过滤-“Unknown column 'DOMAINID' ”排错(sql 模式)】

Q:视图SQL
ELECT  tlk_contacts.item_name as Item_newname FROM  tlk_company,tlk_contacts where tlk_company.ID = tlk_contacts.PARENT;
报错:
*Unknown column 'DOMAINID' in 'where clause'   
是怎么回事呢?
A：改成：SELECT  tlk_contacts.item_name as Item_newname , tlk_contacts.DOMAINID  as  DOMAINID, tlk_contacts.id as id  FROM  tlk_company,tlk_contacts where tlk_company.ID = tlk_contacts.PARENT;试一下。因为平台是根据域和ID进行查询的。后台程序会在您这条sql语句加上domainid和id的条件判断。
摘自danielkaya提问，原帖子链接：
http://www.teemlink.com/bbs/view ... %26amp%3Btypeid%3D2