?? 7.test
字號:
# OK : Simple joinselect staff.first_name, staff.last_name, users.uname from staff, users where staff.staff_id = users.staff_id \p\g# OK : Simple join with aliasesselect S.first_name, S.last_name, U.uname from staff=S, users=U where S.staff_id = U.staff_id \p\g# OK : 3 way select staff.first_name, staff.last_name, users.uname, contact.phone from staff, users, contact where staff.staff_id = users.staff_id and users.staff_id = contact.staff_id\p\g# OK : 3 way with table aliasesselect S.first_name, S.last_name, U.uname, C.phone from staff = S, users = U, contact = C where S.staff_id = U.staff_id and U.staff_id = C.staff_id\p\g# OK : Join with sysvar being carried through the result tableselect S._rowid, S.first_name, S.last_name, U.uname, C.phone from staff = S, users = U, contact = C where S.staff_id = U.staff_id and U.staff_id = C.staff_id\p\g# OK : do some ordering as wellselect S.first_name, S.last_name, U.uname, P.pay_date, P.pay_amount from staff = S, users = U, pay = P where S.staff_id = U.staff_id and U.staff_id = P.staff_id order by S.last_name\p\g# OK : ordering and distinctselect distinct S.first_name, S.last_name, U.uname, P.pay_amount from staff = S, users = U, pay = P where S.staff_id = U.staff_id and U.staff_id = P.staff_id order by S.last_name\p\g
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -