Is it possible to
JOIN tables while creating a view? It doesn’t seem like its possible, it doesn’t seem like I have access to those relational joins.
Here is an example, but it doesn’t seem to work, or I don’t know how to join them.
SELECT u.id, u.contactId, u.contactEmail, u.contactName, c.name FROM Users u JOIN company c ON u.company = c.id
You can see here in our schema these fields, and the company relationship.
I have created a custom column
Users table and stored the ID of the company record to my User. This query works, so I can join on a custom column I just don’t have access to the relational join
SELECT Users.*, Company.companyName FROM Users JOIN Company on Users.companyId = Company.id
Will this be possible one day to join using the relation that already exists?