select
a.*,
b.duty AS duty,
b.dutytime AS duytime,
b.maturetime AS maturetime
from
a
left join
b
on
a.pid = b.pid and b.isnow='是'
left join
c
on
a.pid = c.pid and c.isnow='是'
a.*,
b.duty AS duty,
b.dutytime AS duytime,
b.maturetime AS maturetime
from
a
left join
b
on
a.pid = b.pid and b.isnow='是'
left join
c
on
a.pid = c.pid and c.isnow='是'
a.*,
b1.duty AS duty,
b1.dutytime AS duytime,
b1.maturetime AS maturetime
from
a,
(select * from b where isnow='是') b1,
(select * from c where isnow='是') c1
where
a.pid *= b.pid and a.pid *= c.pid
a.*,
b1.duty AS duty,
b1.dutytime AS duytime,
b1.maturetime AS maturetime
from
a,
(select * from b where isnow='是') b1,
(select * from c where isnow='是') c1
where
a.pid *= b1.pid and a.pid *= c1.pid
a.*,
b1.duty AS duty,
b1.dutytime AS duytime,
b1.maturetime AS maturetime
from
a,
(select * from b where isnow='是') b1,
(select * from c where isnow='是') c1
where
a.pid = b1.pid(*) and a.pid = c1.pid(*) --左右别搞错喽
更正:select
a.*,
b1.duty AS duty,
b1.dutytime AS duytime,
b1.maturetime AS maturetime
from
a,
(select * from b where isnow='是') b1,
(select * from c where isnow='是') c1
where
a.pid = b1.pid(+) and a.pid = c1.pid(+) --左右别搞错喽