Skip to content
Advertisement

SQL query to select from multiple tables and create third table

Can someone please help me with a SQL query? My apologies if a similar question has been asked before. Finding it difficult from other examples I have seen.

I have 2 tables and would like to create a third table.

Table – advisories

Table – customerA

Final Table

Does this look correct?

Thanks for the help.

Advertisement

Answer

I would suggest using the LIKE in the JOIN as follows:

See SQL Fiddle. I have changed the || to CONCAT function.

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