刚刚看到书上说不能够动态的加lookup类型的字段
说的详细点:比如有A(id,a,b,c,d),B(id,e,f,g,h),C(id,i,j,k,l)三个表,代码表为D(code,name,series)
其中A.b,A.c,B.f,C,k有二级代码
这么写对么
select A.a,M.m,B.e,N.n,C.i from A,B,C,(select name as m from A inner join (select code from D where series=A ) on A.b=D.code) M,(select name as m from B inner join (select code from D where series=B ) on B.f=D.code) N
where A.id=B.id and B.id=C.id;
这样就死机了