Question: I am trying to scrape the text from the minutes published in the webpage of the central bank of Brazil:

<https://www.bcb.gov.br/publicacoes/atascopom>

Have tried to use BeautifulSoup as per the code below, but only get empty results

```
url = "https://www.bcb.gov.br/publicacoes/atascopom"
html_text = requests.get(url)
soup = BeautifulSoup(html_text.content, 'lxml')
print(soup.find_all('p', class_='paragrafo'))

```

After doing a lot of research, it seems the problem has to do with the JavaScript, but I do not know how to fix it (new to Python). The same code works fine when **scraping** similar text from other central bank webpages.

Anyone has any idea on how to fix it?

Answer: 
Yes, In case of left join it will take all the rows of the table that is on left side, so in the second query the left table is Check\_In and it doesn't have Eve in it.

you can use the full outer join to get the Eve data in the result.

Use this query

SELECT Profile.Name, Check\_In.CDate
FROM Check\_In
FULL OUTER JOIN Profile ON Check\_In.PID = Profile.ID
That's the reason - if you want to have **all** rows from `Profile`, then you need to use `Profile` In the `FROM` clause - and do a `LEFT JOIN` on `Check_In` - try this:

```
SELECT Profile.Name, Check_In.CDate 
FROM Profile
LEFT JOIN Check_In ON Check_In.PID = Profile.ID

```

The `LEFT JOIN` by definition returns **all rows** from the table to the left of the `JOIN` operator - and joins those rows from the right-hand table that exist (and returns NULL for those rows where the JOIN condition doesn't match the right-hand table).