如何从两个表中查询数据

[lm09]

有这两个表,part_check,Customer_Goods,通过一个字段cgid相连,想查询两个表中所有内容以下语句
SELECT part_check.* , Customer_Goods.* FROM part_check,Customer_Goods where ( (part_check.cgid=Customer_Goods.cgid) and (part_check.Cstyle = '0') AND ( Customer_Goods.GStype= '1' or Customer_Goods.GStype = '3' or Customer_Goods.GStype = '4' or Customer_Goods.GStype = '6' or Customer_Goods.GStype = '7' or Customer_Goods.GStype = '8'))
在sqlserver 查询分析器中行,在ADODataset中不行

[mfc42d]

你的代码没有错,

[yuyulily]

怎么个不行啊，错误信息是什么？

[rabbit9]

看看你的设置有没有问题,问题不出在这句子上》》》》