drop index er_jicxxlb2_v;
create view er_jicxxlb2_v as
select
a.id,
a.xuanxlbsm,
a.csysid,
b.csysname,
b.flag
from
er_jicxxlb a,
p_csys b
where a.csysid *=b.csysid and flag='1';
这个在sql中可实现,在access中怎么实现呢??
...全文
274打赏收藏
sql语句怎么在access中运行例如:
drop index er_jicxxlb2_v; create view er_jicxxlb2_v as select a.id, a.xuanxlbsm, a.csysid, b.csysname, b.flag from er_jicxxlb a, p_csys b where a.csysid *=b.csysid and flag='1'; 这个在sql中可实现,在access中怎么实现呢??