Example of using joins (inner, outer, left, right) with Pharo DataFrame. Customers and orders tables come from http://www.sql-join.com/sql-join-types

customers.st

| customers |

customers := DataFrame
                 withRows:
                     #( ( 1 'George' 'Washington' 'gwashington@usa.gov'
                          '3200 Mt Vernon Hwy' 'Mount Vernon'
                          'VA' 22121 )
                        ( 2 'John' 'Adams' 'jadams@usa.gov'
                          '1250 Hancock St' 'Quincy' 'MA' 02169 )
                        ( 3 'Thomas' 'Jefferson' 'tjefferson@usa.gov'
                          '931 Thomas Jefferson Pkwy'
                          'Charlottesville' 'VA' 22902 )
                        ( 4 'James' 'Madison' 'jmadison@usa.gov'
                          '11350 Constitution Hwy'
                          'Orange' 'VA' 22960 )
                        ( 5 'James' 'Monroe' 'jmonroe@usa.gov'
                          '2050 James Monroe Parkway'
                          'Charlottesville' 'VA' 22902 ) )
                 columnNames:
                     #( customer_id first_name last_name email address
                        city state zipcode ).