分组表表过滤

eternity · 发表于 2014-2-24 16:46:08

请教如何通过产品类别来过滤。。
"SELECT RPRODUCTID , RPRODUCTNAME , (SELECT RCATEGORYNAME FROM DEMO_REPORTPRODUCTCATEGORY WHERE DEMO_REPORTPRODUCTCATEGORY.RCATEGORYID = DEMO_REPORTPRODUCTS.RCATEGORYID) AS RCATEGORYNAME , (SELECT RCOMPANYNAME FROM DEMO_REPORTSUPPLIERS WHERE DEMO_REPORTSUPPLIERS.RSUPPLIERID = DEMO_REPORTPRODUCTS.RSUPPLIERID)AS RCOMPANYNAME, RQUANTITYPERUNIT,RUNITPRICE,RUNITSINSTOCK FROM DEMO_REPORTPRODUCTS where RCATEGORYNAME = '饮料'";
Caused by: java.sql.SQLException: Unknown column 'RCATEGORYNAME' in 'where clause'

wangliang · 发表于 2014-2-24 17:01:56

sql写法有问题吧，写连接查询

eternity · 发表于 2014-2-24 17:14:29

wangliang 发表于 2014-2-24 17:01
sql写法有问题吧，写连接查询

请教一下该怎么写

wangliang · 发表于 2014-2-24 17:27:41

SELECT
      RPRODUCTID
      ,RPRODUCTNAME
      , DEMO_REPORTPRODUCTCATEGORY.RCATEGORYNAME
      , DEMO_REPORTSUPPLIERS.RCOMPANYNAME
      ,RQUANTITYPERUNIT
      ,RUNITPRICE
      ,RUNITSINSTOCK
FROM
      DEMO_REPORTPRODUCTS left join DEMO_REPORTPRODUCTCATEGORY on DEMO_REPORTPRODUCTCATEGORY.RCATEGORYID = DEMO_REPORTPRODUCTS.RCATEGORYID
                        left join DEMO_REPORTSUPPLIERS on DEMO_REPORTSUPPLIERS.RSUPPLIERID = DEMO_REPORTPRODUCTS.RSUPPLIERID
WHERE
      DEMO_REPORTPRODUCTCATEGORY.RCATEGORYNAME = '44444' ;

wangliang · 发表于 2014-3-14 10:14:01

改了 sql可以了吧

		自动登录	找回密码
密码			注册

[结贴] 分组表表过滤