I'm currently working on a project in Laravel.

I have 3 TABLES in MySQL.

Clicks - Costs - Profit

I want to show the data from these 3 tables in one blade.

What's the efficient way to achieve this?

For example: Having a shared same column value in each 3 tables, then returning the query with that value from every table.

Or maybe something like a belongsToMany Eloquent?

CodePudding user response：

I think this is all you want - link

CodePudding user response：

What is the database look like, do they share a foreign key? What data you explicitly want to extract and show to the blade?