大家看看下面的SQL语句的意思:
adoquery1: select c.id, c.name as name ,p.name as teacher
from course c left join person p on c.teacher=p.id
where c.state='1'
有ds_list1对应
能否写成: from course c,person p
where c.teacher=p.id and c.state='1' 另:adoquery2中SQL:
SELECT T.ID, P.ID AS PERSON, P.NAME, D.NAME AS DEPART
FROM TRAINING_PLAN T, PERSON P, DEPARTMENT D
WHERE T.COURSE=:ID
AND T.PERSON=P.ID
AND P.DEPARTMENT=D.ID
ORDER BY D.ID
adoquer2.datasource : ds_list1 :不理解为什么在adoquery中设置
对应的是: ds_list2 (dataset:adoquer2)另建一个adotable1 tablename:training
mastersource: ds_list2
masterfield: 设置时提示“至少一个参数没有被指定值”
请问为什么?该如何设置?
分不多了,请大家原谅!
adoquery1: select c.id, c.name as name ,p.name as teacher
from course c left join person p on c.teacher=p.id
where c.state='1'
有ds_list1对应
能否写成: from course c,person p
where c.teacher=p.id and c.state='1' 另:adoquery2中SQL:
SELECT T.ID, P.ID AS PERSON, P.NAME, D.NAME AS DEPART
FROM TRAINING_PLAN T, PERSON P, DEPARTMENT D
WHERE T.COURSE=:ID
AND T.PERSON=P.ID
AND P.DEPARTMENT=D.ID
ORDER BY D.ID
adoquer2.datasource : ds_list1 :不理解为什么在adoquery中设置
对应的是: ds_list2 (dataset:adoquer2)另建一个adotable1 tablename:training
mastersource: ds_list2
masterfield: 设置时提示“至少一个参数没有被指定值”
请问为什么?该如何设置?
分不多了,请大家原谅!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货