Hiral Posted March 4, 2019 Share Posted March 4, 2019 PLEASE HELP IN A QUERY. i AM TRYING TO DO SELF JOIN WITH A QUERY WHICH 2 OR MOR ELEFT OUTER JOINS IN IT. HOW TO DO SELF JOIN HERE . THANKS IN ADVANCE. Link to comment Share on other sites More sharing options...
justsomeguy Posted March 4, 2019 Share Posted March 4, 2019 You would need to give the entire query an alias, and then you can join it with any other query, including itself. It seems like that would be inefficient though, the joined query won't have any indexes that will help speed things up. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now