MySQL中关联查询相关语句
摘要:
-- emp和job查询 SELECT t1.`id`, t1.`ename`, t1.`salary`, t2.`jname`, t2.`descriptions` FROM emp t1,job t2,dept t3 WHERE t1.`job_id`=t2.`id`AND t3.`id`=t1.`dept_id`; -- 查询工资的等... 阅读全文
posted @ 2019-05-02 22:48 认真的谁 阅读(219) 评论(0) 推荐(0) 编辑