I'm looking for something rather easy for you who know a lot about SQL, but I am really confused.
I want to find out which of our customers have the same phone (I find this easy), but I also want to bring in more information for those who have the same phone number.
FirstName LastName Age Telephone
Eva Mendes 45 +302101234567
Ryan Gosling 38 +302101234567
So, in this case, 2 customers have the same phone number. So what I want is a query to search for same phones and if find (like example), then return 1 row like this:
1_FirstName 1_LastName 1_Age SAME_Telephone 2_FirstName 2_LastName 2_Age
Eva Mendes 45 +302101234567 Ryan Gosling 38
I have tried with left join options, with min and max options and various groups but it didn't work properly in all cases.
I also searched it a lot on google but while I found too many duplicate scripts, I didn't find anything that fit my need.
Ι would appreciate it if you spent your time helping me
Thanks a lot,