I am having trouble setting up a view between two tables. For example, I have a customer table and an order table. I want to create a view in the order table that shows information about the customer. The customer table also has a lookup column to the user table which has the customer name information. In the view, I setup a customer column from the related customer table and can see the customer id but I can't see any user information from the user lookup column.
How do you setup a view that joins two tables so I can see all the data from each table including lookup columns?
