2 Replies Latest reply: Sep 19, 2016 11:44 AM by Andres Prado RSS

    Left join query between two already imported tables

    Victor Salling

      I have loaded two tables users (users_id, users_name...) and organizations (organizations_id, organizations_name...) from a postgreSQL database in the editor.

      Now I would like to create a table users2 (users_id, users_name, users2_organizations_name, users2_organizations_id) containing the characteristics of the users plus those of the organizations using a simple LEFT JOIN query.

       

       

      I don't know what to write in the editor for that despite many researches. I would love a bit of help !!

       

       

      Thanks a lot !