P
pchddcat
Unregistered / Unconfirmed
GUEST, unregistred user!
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select dan.date_1,dan.pid,dan.gid,goods.gname,people.pname,dan.num*goods.gprice as tol from dan,goods,people where');
adoquery1.SQL.Add('pid' +'='+edit1.Text);
adoquery1.Open;
//列名'pid'不明确
因为是多个表,怎样使用视图功能做查询
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select dan.date_1,dan.pid,dan.gid,goods.gname,people.pname,dan.num*goods.gprice as tol from dan,goods,people where');
adoquery1.SQL.Add('pid' +'='+edit1.Text);
adoquery1.Open;
//列名'pid'不明确
因为是多个表,怎样使用视图功能做查询