[sql] Select rows which are not present in other table

SELECT l.ip, tbl2.ip as ip2, tbl2.hostname
FROM   login_log l 
LEFT   JOIN (SELECT ip_location.ip, ip_location.hostname
             FROM ip_location
             WHERE ip_location.ip is null)tbl2

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to null

• getElementById in React • Filter values only if not null using lambda in Java8 • Why use Optional.of over Optional.ofNullable? • How to resolve TypeError: Cannot convert undefined or null to object • Check if returned value is not null and if so assign it, in one line, with one method call • How do I assign a null value to a variable in PowerShell? • Using COALESCE to handle NULL values in PostgreSQL • How to check a Long for null in java • Check if AJAX response data is empty/blank/null/undefined/0 • Best way to check for "empty or null value"

Examples related to left-join

• MySQL select rows where left join is null • How to return rows from left table not found in right table? • How to specify names of columns for x and y when joining in dplyr? • Select rows which are not present in other table • SQL LEFT-JOIN on 2 fields for MySQL • Combine two pandas Data Frames (join on a common column) • SQL LEFT JOIN Subquery Alias • How to use mysql JOIN without ON condition? • LEFT JOIN only first row • MySQL - sum column value(s) based on row from the same table

Examples related to exists

• Select rows which are not present in other table • How to fix "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS" error? • Check if record exists from controller in Rails • sql: check if entry in table A exists in table B • How to exclude records with certain values in sql select • SQL - IF EXISTS UPDATE ELSE INSERT INTO • Linq select objects in list where exists IN (A,B,C) • PL/pgSQL checking if a row exists • How to Check if value exists in a MySQL database • MongoDB: How to query for records where field is null or not set?