select *,type=(select type from 表B),state1=(select state1 from 表c), state2=(select state2 from 表c) from 表A
select *,type=(select type from 表B),state1=(select state1 from 表c), state2=(select state2 from 表c) from 表AORselect *,(select type from 表B) AS type ,(select state1 from 表c) as state1, (select state2 from 表c) as state2 from 表A
select Cid,Cname,CPid,B.*,C.* from A,B,C
select *,type=(select type from B),state1=(select state1 from c),state2=(select state2 from c) from A
select * from a , (select top 1 * from b cross join @c c) d
select * from a , (select top 1 * from b cross join c) d 不好意思,多写了个@c
state2=(select state2 from 表c)
from 表A
select *,type=(select type from 表B),state1=(select state1 from 表c),
state2=(select state2 from 表c)
from 表AORselect *,(select type from 表B) AS type ,(select state1 from 表c) as state1,
(select state2 from 表c) as state2
from 表A
,
(select top 1 * from b cross join @c c) d
,
(select top 1 * from b cross join c) d
不好意思,多写了个@c