Can MySQL join work on the same table?

[sanjay123]

Hello, I want to use join in mysql. Will it work? I have table1 with columns id, a, b, c, d. I want to open a loop as many times as the number of records, look at the ids one by one, and list those whose data in columns a, b, c, d are the same. Can I do this with join? Purpose: to list those with the same abcd along with their ids.