📄 view book_custom_infor.sql
字号:
create view book_custom_infor
as
select custom_type,custom_id,custom_name,custom_sex,custom_telephone,custom_room,r_style_name,room_combine,r_style_price,r_style_conprice,r_style_discount,custom_intime,custom_outtime,custom_used,custom_deposit,custom_explain
from custom_infor,room_infor,r_style_infor
where custom_room=room_id and custom_team='0' and custom_state='2'and room_style=r_style_id
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -