Pulling Data from Three Tables with No Similar Look-Up Column Using SQL Query Table?

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