FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
postgresql/outer_join_practice.sql at master · S567655/postgresql · GitHub
S567655
/
postgresql
Public
forked from
michaelmiaomiao/postgresql
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
postgresql
/
outer_join_practice.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
14 lines (14 loc) · 335 Bytes
Breadcrumbs
postgresql
/
outer_join_practice.sql
Copy path
File metadata and controls
14 lines (14 loc) · 335 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
--
SELECT film.film_id,
--
title,
--
inventory_id
--
FROM film
--
LEFT JOIN inventory ON inventory.film_id = film.film_id;
SELECT
film
.
film_id
,
title,
inventory_id
FROM
film
LEFT JOIN
inventory
ON
inventory
.
film_id
=
film
.
film_id
--
WHERE inventory.film_id IS NULL
--
ORDER BY film.film_id;
WHERE
inventory_id IS
NULL
ORDER BY
title;
Back
|
FazBrowse Home
|
New Git URL