Skip to content
Advertisement

How self join works [closed]

I have a customer table:

I want to have a new column referred_name that should show who referred which customer based on referred_id, the output should be:

Can someone please help me with the query

Thanks

Advertisement

Answer

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement