Join is removed with "Removing invalid MBQL clause" joining two columns together with the same field ID

[calherries]

Describe the bug

If you join two tables together on a column with the same field ID in the notebook editor, the join gets removed on save.

To Reproduce

Following the first three steps from #12930:

1. Create question Q1 - Orders join with Products and People, summarized by Count, grouped by Category and Source
   
2. Create question Q2 - Products, summarized by Average Rating, grouped by Category
   
3. Custom question > Saved Questions > Q1 and join Q2 on Category.

4. Click "Save". The Join should be removed with only Q1 remaining:

Expected behavior

Join should work

Logs

The browser console shows this warning on save:

Information about your Metabase installation

master, commit 7587d3cf1a6e35e593f900f98d266591a6160a31

Severity

High

Additional context

No response