Skip to content
Advertisement

Add join and search in columns for any string

I have these Postgres tables:

I use this SQL query:

How I extend this SQL query to search also in table employees by employee id and filter the result by any character found in table columns first_name and last_name?

Advertisement

Answer

You can join the new table using employee_id:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement