Join in sql that returns all

0

I have two tables, the one of episodes and of episodes seen, I need to make a query that will join the two by the id of the episode, but I do not want the episodes that are not in the second table do not come in the result, an example:

Thisisthefirsttable

Thisisthesecondtable

Putting the two together I want this

If you have any questions, please ask me. Thanks

    
asked by anonymous 24.10.2017 / 19:21

1 answer

2

There are several ways to make joins, in your case you have to do a joining left, which only considers the records on one side of the table if there is no other, below an illustrative image to get better explained with examples: / p>

    
24.10.2017 / 19:28