Select nhfenlei. The key, the description, the sum (je) from nhinfo join nhfenlei on nhinfo, fenlei like nhfenlei. Key + '%' left join fptabale on nhinfo. Nhcode=fptabale. Dfcode group by nhfenlei. The key, the description having sum (je) & gt;=0 order by nhfenlei. Key



Including nhfenlei is classification, nhinfo archive table, fptabale is data table

According to the key and the description of nhfenlei classification statistical amount

CodePudding user response:

Suggestions for sysbase database, PB's own, and SQL server grammar are very similar.

CodePudding user response:

Change is not working is normal, the database, SQL is generally need to write,

CodePudding user response:

In the ACCESS under test, some grammar is not universal