我想显示产品表中所有具有相同产品编号的行。我尝试了这段代码,但出现了错误
- 00000-“列定义不明确”
WITH cte AS(
SELECT product_no
FROM product
GROUP BY product_no
HAVING COUNT(*) > 1)
select * from product v
inner join cte on cte.product_no = v.product_no
where
accOUNTING_GROUP not in ('1000','1200')
我想要的结果:
Product_no produc_Descrip accOUNTING_GROUP acc_group_descr
123 bike 1001 semi-finish-A
123 bike 1002 semi-finish-B
1234 motor 1005 ........
1234 motor 1006 ........
.... ....... .... ........