1。如何让一个模态窗体在指定的位置显示?(50分)2。一个查询ACCESS数据的问题三张表联接查询,语句如下但不能在ACESS中通过。
要返回表ARRIBC中的全部记录。 (50分)SELECT
ArriBc.bh,ArriBc.rq,ArriBc.bc,kqsjb.skcs,kqsjb.sj5,kqsjb.sj6,JB.jb_start,JB.jb_end
FROM ArriBc inner join kqsjb on Arribc.bc=kqsjb.bc inner join JB on Arribc.bh=jb.bh and Arribc.rq=jb.jb_rq;分不够可以加!
要返回表ARRIBC中的全部记录。 (50分)SELECT
ArriBc.bh,ArriBc.rq,ArriBc.bc,kqsjb.skcs,kqsjb.sj5,kqsjb.sj6,JB.jb_start,JB.jb_end
FROM ArriBc inner join kqsjb on Arribc.bc=kqsjb.bc inner join JB on Arribc.bh=jb.bh and Arribc.rq=jb.jb_rq;分不够可以加!
procedure TForm1.Button1Click(Sender: TObject);
begin
form2.Left:=100;
form2.Top:=100;
form2.ShowModal;
end;
inner join B on A.id=B.id
inner join C on B.id=C.id
inner join D on C.id=D.id
要衔接着上面的
不能够
A
inner join B on A.id=B.id
inner join C on A.id=C.id
inner join D on A.id=C.id你看看怎么灵活处理一下吧
或者用where语句不要用join
2、用where
procedure TForm1.Button1Click(Sender: TObject);
begin
form2.Left:=100;
form2.Top:=100;
form2.Width:=400;
Form2.Height:=300;
form2.ShowModal;
end;2.
SELECT
ArriBc.bh,ArriBc.rq,ArriBc.bc,kqsjb.skcs,kqsjb.sj5,kqsjb.sj6,JB.jb_start,JB.jb_end
FROM ArriBc ,kqsjb,jb
where Arribc.bc=kqsjb.bc and
Arribc.bh=jb.bh and Arribc.rq=jb.jb_rq;
begin
//设定位置
form2.Left:=100;
form2.Top:=100;
form2.Width:=400;
Form2.Height:=300;
// 显示
form2.ShowModal;
from2.free;
end;2.
SELECT
ArriBc.bh,ArriBc.rq,ArriBc.bc,kqsjb.skcs,kqsjb.sj5,kqsjb.sj6,JB.jb_start,JB.jb_end
FROM ArriBc ,kqsjb,jb
where Arribc.bc=kqsjb.bc and
Arribc.bh=jb.bh and Arribc.rq=jb.jb_rq;
SELECT ArriBc.bh, ArriBc.rq, ArriBc.bc, JB.JB_START, JB.JB_END, kqsjb.SJ5, kqsjb.SJ6
FROM kqsjb RIGHT JOIN (JB RIGHT JOIN ArriBc ON (JB.JB_RQ = ArriBc.rq) AND (JB.BH = ArriBc.bh)) ON kqsjb.BC = ArriBc.bc;