我用query写查询,然后用报表输出结果,语句如下:query1.Close;
query1.SQL.Clear;
query1.SQL.add('Select jbzl.Salary_ID,Company_ID,Company_Name,Employee_Name,');
query1.SQL.Add('gz.Salary_ID,Salary_Year,Salary_Month,Basepay,Float_Salary,Age_Salary,Others,');
query1.SQL.Add('Ensurence_Discount,Tax_Discount,House_Discount,Elec_Discount,TV_discount,');
query1.SQL.Add('(Basepay+Float_Salary+Age_Salary+Others)as Total_Salary, ');
query1.SQL.Add('(Ensurence_Discount+Tax_Discount+Elec_Discount+TV_Discount+House_Discount)as Total_Discount,');
query1.SQL.Add('(Basepay+Float_Salary+Age_Salary+Others-Ensurence_Discount-Tax_Discount-Elec_Discount- ');
query1.SQL.Add('-House_Discount)as Real_Salary');
query1.SQL.Add('from gz,jbzl');
query1.SQL.Add('where (jbzl.Salary_ID=gz.Salary_ID)');
query1.SQL.Add('and (gz.Salary_ID=:var1)');
query1.Params[0].AsString:=efsid.Text;  //efsid 是一个edit组件
query1.Prepare;
query1.Open;
rvproject1.Execute;怎么查询结果是整个表的记录?? 在线等