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.
Update:
I have created a custom column companyId in 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?