How to Join a table with Other (result) Tables ? Complex one !
- From: "velu" <velu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 02:40:34 -0700
Here is the situation
Table 1 : tbl_documents
docID docName
1 aaa
2 bbb
3 ccc
Table 2 : tbl_Rating
ratID rating docID
1 3 1
2 5 1
3 2 1
4 3 2
The queary I need is to display the result in this form. must be like this
docID docName Avaragerating
1 aaa 3
2 bbb 3
3 ccc 0
NOTE : For getting the average I used this queary “SELECT SUM(rating) As
RatingSum, COUNT(*) As RatingCount FROM tbl_Rating WHERE tbl_rating.docID =
tbl_documents.docID”
PLs help me ?
Thx
.
- Follow-Ups:
- Re: How to Join a table with Other (result) Tables ? Complex one !
- From: Steve Kass
- Re: How to Join a table with Other (result) Tables ? Complex one !
- Prev by Date: Re: Ordering Results
- Next by Date: Re: How to Join a table with Other (result) Tables ? Complex one !
- Previous by thread: Ordering Results
- Next by thread: Re: How to Join a table with Other (result) Tables ? Complex one !
- Index(es):