select a.id,a.name from a inner join b on a.id=b.id 取出来在gridview绑定即可
a表中的项目ID和单位ID 合并成一个外键 PID就可以了 select id,name from a as aa inner join b as bb on aa.PID=bb.id where bb.TypeClass=自己传参
谢谢你们 解决了 但是你们能帮我简化下吗 select a.takeid, (select name from system_threetable where a.comp_id=system_threetable.id and typeclass=1) as compname , (select name from system_threetable where a.dept_id=system_threetable.id and typeclass=6) as deptname, (select project_name from base_project_p where a.project_id=base_project_p.project_id) as projectname, a.take_date, (select Item_name from base_mat where a.Item_no=base_mat.Item_no) as Item_name, (select unitname from base_unit where a.item_unit=base_unit.unitname) as unitname, a.item_num,a.make_man,a.re, (select name from system_threetable where a.dept_littid=system_threetable.id ) as deptlittctname from zl_takemat a
select a.takeid, (select name from system_threetable where a.comp_id=system_threetable.id and typeclass=1) as compname , (select name from system_threetable where a.dept_id=system_threetable.id and typeclass=6) as deptname, b.project_name,a.take_date,c.Item_name,d.unitname , a.item_num,a.make_man,a.re, (select name from system_threetable where a.dept_littid=system_threetable.id ) as deptlittctname from zl_takemat a left join base_project_p b on a.project_id=b.base_project_p.project_id left join base_mat c on a.Item_no=c.base_mat.Item_no left join base_unit d on a.item_unit=d.base_unit.unitname红色的那句话不好理解,,应该也是可以写成下面那样的
我看了好久,我的理解是如下,不知道对不对: 有一个gridview 查询列如下 id ,(项目部)name ,(单位)name要从表a 中 字段包括: id ,项目部id ,单位id (a表 id , 项目部id ,单位id 是3个字段?)表b中的字段包括:id ,name, typeclass ,(typeclass 1代表项目部ID,2代表单位ID ,b的id和a表一样?) id name typeclass 1 山东 1 2 山海 1 3 财务 2查询gridview的列显示 : id ,(项目部)name ,(单位)name
不是三个字段 有 takeid Comp_id Dept_id Project_id Take_date Item_no Item_unit Item_num Make_man Re deptlittid b表字段 id name Code Typeclass 项目部typeclass=1 单位是6 外协单位是7 其他表就简单了 根据两表id关联查询就行 比如c表 unitid Unit name sql我已经写对了 能简化吗
取出来在gridview绑定即可
select id,name from a as aa inner join b as bb on aa.PID=bb.id where bb.TypeClass=自己传参
select a.takeid,
(select name from system_threetable where a.comp_id=system_threetable.id and typeclass=1) as compname ,
(select name from system_threetable where a.dept_id=system_threetable.id and typeclass=6) as deptname,
(select project_name from base_project_p where a.project_id=base_project_p.project_id) as projectname,
a.take_date,
(select Item_name from base_mat where a.Item_no=base_mat.Item_no) as Item_name,
(select unitname from base_unit where a.item_unit=base_unit.unitname) as unitname,
a.item_num,a.make_man,a.re,
(select name from system_threetable where a.dept_littid=system_threetable.id ) as deptlittctname
from zl_takemat a
怎么写转换 最好是vb.net的写法 。。
(select name from system_threetable where a.comp_id=system_threetable.id and typeclass=1) as compname ,
(select name from system_threetable where a.dept_id=system_threetable.id and typeclass=6) as deptname, b.project_name,a.take_date,c.Item_name,d.unitname , a.item_num,a.make_man,a.re,
(select name from system_threetable where a.dept_littid=system_threetable.id ) as deptlittctname
from zl_takemat a left join
base_project_p b on a.project_id=b.base_project_p.project_id
left join base_mat c on a.Item_no=c.base_mat.Item_no
left join base_unit d on a.item_unit=d.base_unit.unitname红色的那句话不好理解,,应该也是可以写成下面那样的
有一个gridview 查询列如下 id ,(项目部)name ,(单位)name要从表a 中 字段包括: id ,项目部id ,单位id (a表 id , 项目部id ,单位id 是3个字段?)表b中的字段包括:id ,name, typeclass ,(typeclass 1代表项目部ID,2代表单位ID ,b的id和a表一样?)
id name typeclass
1 山东 1
2 山海 1
3 财务 2查询gridview的列显示 : id ,(项目部)name ,(单位)name
takeid
Comp_id
Dept_id
Project_id
Take_date
Item_no
Item_unit
Item_num
Make_man
Re
deptlittid
b表字段
id
name
Code
Typeclass
项目部typeclass=1 单位是6 外协单位是7
其他表就简单了 根据两表id关联查询就行
比如c表
unitid
Unit name
sql我已经写对了 能简化吗