How to regroup two tables effectively ?

[SRP]

Hello everyone !

I have a problem i can't solve

The link

I have three tables : 

The first with every articles views on one month

The second with every views for every article

The third with every article on my database (half has 0 views)

I want to regroup to have every views in one table and when the article has 0 views, the number is 0 in "number of views for this article". I don't know how to do that, maybe with related ?

Sorry for my english, i hope you can understand and help me !

[SRP]

Hello, i still need help 🙂

[Ashish_Mathur]

Hi,

Share 3 simple datasets and show the expected result.

[SRP]

What do you mean by share, do you want me to update a file with my data ? I'm not sure if you saw but i have posted a screen with the problem 

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[SRP]

I think you may have a problem with this account aha. If u need the file here : https://we.tl/t-3tM7ffs3Hh

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.

[Syndicate_Admin]

A screenshot doesn't help at all. I need a file to work with. You can share 3 simple datasets and display the expected result in a simple Excel file. Share the download link for the Excel file.