Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL> no rows selected

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,



Above query works fine because record exists in each table row but when I add:


Then it displays "no rows selected" as this table don't have any record for linked cv_id

How can I ignore the table if no record exists to display the rest of records?

Thanks in anticipation

 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
still waiting for reply
 
sachin potu
Greenhorn
Posts: 21
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if i am not wrong , you must use Left join, instead of Equi join
 
Farakh khan
Ranch Hand
Posts: 833
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks sachin
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic