I have two tables: one is a list of websites (some duplicated), each website has its own unique ID, even if the site is duplicated. The other is a list of the same websites (but unique) with web status codes in another column.
I would like to bind the second table to the first "duplicated urls" table such that the original first table with duplicated websites has the html status codes next to each website.
I can't figure out how to do this since each table is of different lengths, although the websites are the same. Each website has a status code, but duplicates have different IDs.
First table:
| ID | Website |
|---|---|
| 1 | website1.com |
| 2 | website2.com |
| 3 | website2.com |
| ... | ... |
Second table:
| Website | status |
|---|---|
| website1.com | 200 |
| website2.com | 200 |
| website3.com | 404 |
| ... | ... |
Goal:
| ID | Website | Status Code |
|---|---|---|
| 1 | website1.com | 200 |
| 2 | website2.com | 200 |
| 3 | website2.com | 200 |
| 4 | website3.com | 404 |
| ... | ... | ... |
