demo_mysql_right_join.py:
C:\Users\My Name>python demo_mysql_right_join.py
('John', 'Chocolate Heaven')
('Peter', 'Chocolate Heaven')
('Amy', 'Tasty Lemon')
(None, 'Vanilla Dreams')