oracle中tax就下面这个程序中得taxc我看不懂请高人指点.selectround(sum((a.amount+a.discamount)*(1+c.vatperc/100)),2)销售金额,count(distincta.tillno||a.invoiceno)来客fromshtbinvoicelinea,shtbinvoiceb,taxcwhere

Question

oracle中tax 就下面这个程序中得tax c我看不懂请高人指点.
select round(sum((a.amount+a.disc_amount)*(1+c.vat_perc/100)),2) 销售金额,count(distinct a.till_no||a.invoice_no) 来客
from sh_tb_invoice_line a,sh_tb_invoice b,tax c
where a.till_no=b.till_no
and a.invoice_no=b.invoice_no
and a.vat_no=c.vat_no
and a.run_date=to_date(&日期,'yyyymmdd')

Answer 1

tax是表名或者是视图名 tax c的意思是给tax起个别名叫C