Pulling Data from Three Tables with No Similar Look-Up Column Using SQL Query Table?
Hi,
I want to pull data from three tables, ('Companies, CRM', 'Tickets, Desk' and 'Timesheets, Projects'). Is this possible? I can't work out how I would be able to do this is as far as I'm aware, no identical column I can use as a look-up column across the three datasets. I have tried creating a formula column in each set of data, however I have now learnt that you cannot create a look-up column with a formula column. Any help on the matter would be great!
Thanks,
Joe