3C健忘人 - 疑難排除不求人 - no more ask for IT help

1. 安裝 libwebkit-gtk sudo apt install libwebkit* 2. 安裝 pulse from app store 開啟store，搜尋 pulse 3. 執行後，點選 +，輸入ssl vpn位址，按connect，如下圖 (圖一) 參考 https://kb.pulsesecure.net/articles/Pulse_Secure_Article/KB40277/?l=en_US&fs=RelatedArticle https://docs.pulsesecure.net/WebHelp/Content/PCS/PCS_AdminGuide_8.2/Using%20Pulse%20Secure%20Linux%20UI.htm

有些特殊條件查詢，需要利用到組合式或JOIN方式查詢。例如：我們要查詢該表格內，有符合在其他表格的條件，皆不要列出的資料。此時可以用 select * from this_table where condition not in ( select condition from another_table ); 或 select * from this_table except select condition from another_table; 參考資料 https://stackoverflow.com/questions/8768254/select-values-from-a-table-where-exclude-values-in-another-table https://mariadb.com/kb/en/library/subqueries-and-joins/