select B.bill_no 订单号,C.state_name 订单状态名称,A.user_name 用户姓名 from user_info as A inner join bill_info as B on A.user_id = B.user_id inner join sate_info as C on B.state_code= C.state_code where A.user_id = 用户ID
select user_name, bill_no, state_name from user_info as u, bill_info as b, state_info as s where u.user_id = b.user_id and b.state_code = s.state_code and u.user_id = '1'
from user_info as u, bill_info as b, state_info as s
where u.user_id = b.user_id
and b.state_code = s.state_code
and u.user_id = '1'