我在发言中引用了KQ,在我管理我的节目时,我从一个检索数据库中选择了这个错误。 我认为,这是正确的,但似乎并非如此。 我如何调整这一选择? 该守则如下:
"select distinct(brought_price) as [Price], select sum(brought_qtty) as [Ordinary] from brought_coffee where " & _
"coffee_grade=O, select sum(brought_qtty) as [Premium] from brought_coffee where" & _
"coffee_grade=P, sum(brought_qtty) as [Total Qtty]" & _
", sum(brought_paid) as [paid], " & _
"sum(brought_bal) as [Balance]" & _
"from brought_coffee, farmer where brought_date=#" & dtc.Text.Trim & "# and farmer_centre= " & cc.Text.Trim & _
" and farmer.farmer_num=brought_coffee.farmer_num"