How To: Full Outer Join In MySQL (2 Min) скачать в хорошем качестве

How To: Full Outer Join In MySQL (2 Min)

In this tutorial, you'll learn how to do a full outer join in MySQL. — Facebook:   / gokcedbsql   — Video Transcript: — Hi guys, this is Abhi from Gokcedb. In this video, you're going to learn how to do a full outer join in the MySQL database. Let's start by looking at the entity relationship diagram. I have 15 tables in my database right now but in this tutorial, we'll mostly be running queries on the property and the property underscore taxes table. The property underscore ID column in the property taxes table is a foreign key and references the ID column in the property table. Say we wanted to select the property number, sizing acres, and property state from the property table and the property taxes yearly amount from the property taxes table. To do that, you can either use a left join right join, or an inner join. However, if you wanted to perform a full outer join, you'll have to do a union between the left join and the right join. This is because my sequel doesn't offer an out-of-the-box capability to run a full outer join. I'm also using order by clause to sort the output by the taxes column in descending order. To execute this SQL file, I'll be using a MySQL Alisa where I'm passing the authentication details using a config file. Let's input this SQL file to the MySQL Alias. As you can see we got 510 rows in our result set. Note the union keyword gets rid of all the duplicates in the result set. To keep the duplicates use union all instead. Now we got 738 rows returned which also includes all the duplicates. You can also use the limit keyword to restrict the output to say 10 rows only. Nother thing, to keep in mind is to use an Alias for the column that you're using in the order by clause. Watch what happens when I get rid of the taxes Alias, I get an error. There you have it. Make sure you like, subscribe, and turn on the notification bell. Until next time. SELECT property.property_number, property.property_size_in_acres, property.property_state, property_taxes.property_taxes_yearly_amount AS 'taxes' FROM property LEFT JOIN property_taxes ON property.id = property_taxes.property_id UNION ALL SELECT property.property_number, property.property_size_in_acres, property.property_state, property_taxes.property_taxes_yearly_amount AS 'taxes' FROM property RIGHT JOIN property_taxes ON property.id = property_taxes.property_id ORDER BY taxes DESC