2017-4-24(1493037086057未命名文件 测试资源是否正确上传
![测试图片 测试图片](https://images2015.cnblogs.com/blog/547226/201704/547226-20170427112018772-1460340902.png)
测试图片
![sdfsdf sdfsdf](https://images2015.cnblogs.com/blog/547226/201704/547226-20170427112020381-915928585.png)
sdfsdf
![timg www](https://images2015.cnblogs.com/blog/547226/201704/547226-20170427112022272-390383397.gif)
timg
SELECT *
FROM author a
JOIN book b USING (author_id)
UNION
SELECT a.*, NULL, NULL, NULL, ..., NULL
FROM (
SELECT a.*
FROM author a
EXCEPT
SELECT a.*
FROM author a
JOIN book b USING (author_id)
) a
- SELECT *
- FROM author a
- LEFT JOIN book b USING (author_id)
- SELECT first_name, last_name
- FROM customer
- INTERSECT
- SELECT first_name, last_name
- FROM actor
- SELECT first_name, last_name
- FROM customer
- EXCEPT
- SELECT first_name, last_name
- FROM staff
- ORDER BY 1, 2
欢迎ssss使用 {小书匠}(xiaoshujiang)编辑器,您可以通过设置里的修改模板来改变新建文章的内容。