• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

query join

 
Eshwin Sukhdeve
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I need pne help in query.I have 2 table Table1 ,Table 2.in Table1 one column is there "Status" which contains the values fixed,resolved..etc and I have
to group by this values..based on some id.now one more table is there which having columns fixed,resolved..etc..this columns contains values..0,1,2..etc.
now I have to show output like this

Table1 Table2
fixed 3(total no of count for fixed column in Table 2)
resolved 3
---"----

Thanks



 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is quite basic stuff. I'd suggest reading some SQL tutorial and then trying to write the query yourself. If I understand your problem correctly, you'll need to utilize select, inner join and a group by (these keywords might help you find the relevant parts of the tutorial sooner).

If you get stuck, post here what you've tried. We'll be glad to help you, but we're NotACodeMill (⇐ click).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic