• 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
Sheriff
Posts: 36027
431
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
Boost this thread!