• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is it possible to do Self Join of a Temporary table?

 
Chetan Balasubramanya
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SQL queries are relatively new for me. Started learning the same. I have a question.

Is it possible to do Self Join of a Temporary table? If so, could you please give an example.

Thanks in advance for any possible help you provide on this.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Chetan,
It should be. Your temporary table has a name, right? If so, you mention the name twice in your query to do the join.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic