MySQL: Join Three Tables to get data in MySQL workbench | Hands On Tutorial | TechGeekyArti

Nice and piece information

I'm doing the same but not working... Showing error...

This is inner join, But how do we get full outer join in sql workbench. I'm getting error while using outer join, but tried with union for combining two tables. But for three how can i get full outer join, Can you give me an example?

Hi this video was very helpful but I need some extra help.
I have 2 tables and I only want to display the items from table1 -(minus) table2.
I only want to display items from table 1 which does not appear in table 2.

Both the table have some similar items with minor changes but they have one similar column.

Would be grateful to you if you could help me out with this one.
thanks

Mam you are to good

How you put condition in where clause if same id is exist on more than one table.. Once i have tried.. Result is not same when i have taken the same id from different tablr