-- select * from yonghu where login_name='lhp' and login_pwd='123'
-- select * from juese
-- select * from yonghu where yonghu_id=1
--select juese_id from juese where juese_id=2
-- select * from juese where juese_id in(
-- select juese_id from yonghu_juese where yonghu_id=
-- (select yonghu_id from yonghu where login_name='lhp' and login_pwd='123')
-- )
-- select * from yonghu
-- select * from yonghu where login_name='lhp' and login_pwd='123'
-- select * from juese
--select juese_id from yonghu_juese where yonghu_id=1
--select * from juese where juese_id=2
select * from juese
where juese_id in(
select juese_id from yonghu_juese
where yonghu_id=(
select yonghu_id from yonghu where login_name='cx' and login_pwd='456'
)
)
select * from juese j,juese_quanxian jq ,quanxian q
where j.juese_id=jq.juese_id and jq.quanxian_id=q.quanxian_id
select * from juese j ,juese_quanxian jq, quanxuan q where j.juese_id=jq.juese_id and jq.quanxian_id=q.quanxuan_id
select * from quanxuan q,quanxian_caidan qc,caidan c
where q.quanxuan_id=qc.quanxian_id and qc.caidan_id=c.caidan_id
select y.*,c.* from
yonghu y,yonghu_juese yj,juese j
,juese_quanxian jq ,quanxuan q
,quanxian_caidan qc,caidan c
where y.yonghu_id=yj.yonghu_id and yj.juese_id=j.juese_id
and j.juese_id=jq.juese_id and jq.quanxian_id=q.quanxuan_id
and q.quanxuan_id=qc.quanxian_id and qc.caidan_id=c.caidan_id
and y.login_name='lhp' and y.login_pwd='123'
select * from v_yonghu_caidan where login_name='jzs' and login_pwd='789'
吧这写语句放这里---用的时好找-----------------------------