sql
1 SELECT 2 ct.call_no AS no, 3 ct.call_name AS name, 4 ct.call_tel AS tel, 5 ct.call_subject AS subject, 6 ct.call_comment AS comment, 7 ct.call_receive AS receive, 8 ct.call_regist AS regist, 9 sft.staff_l_name 10 FROM 11 dot_tbl_request_call AS ct 12 LEFT JOIN 13 dot_tbl_staff AS sft 14 ON 15 ct.call_no=sft.staff_no 16 WHERE 17 ct.del_flg = 0 18 sft.del_flg = 0 19 ORDER BY 20 ct.call_no DESC;
WHERE
ct.del_flg = 0
sft.del_flg = 0
この文を機能させて繋げるには、どのように書けば良いでしょうか?
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2017/06/15 08:29
2017/06/15 08:30
2017/06/16 05:06
2017/06/16 05:17