L
L
lexstile2020-11-07 00:28:18
SQL
lexstile, 2020-11-07 00:28:18

How to write a query to search across multiple tables?

There is an events table with fields: i d, name, description
There is a countries table :
5fa5bf1a19639129865942.png
There is an event_to_country table :
5fa5bf5acd89a331546716.png

How to search for events by fields: events.name || events.description || countries.name?
An unlimited number of countries can be tied to an event, but they are not repeated.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question