jQuery in Action, 2nd edition*
The moose likes Oracle/OAS and the fly likes query join Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "query join" Watch "query join" New topic
Author

query join

Eshwin Sukhdeve
Ranch Hand

Joined: Mar 15, 2012
Posts: 80
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

Joined: Aug 22, 2010
Posts: 3606
    
  60

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).
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: query join
 
Similar Threads
Problem with joining of two tables with Hibernate
how to map column if there is no relationship??
Improving performance of view
Select 1
Java and database