select joins from two table in mysql
i have to two table agency_rating and agency_registration from that agency_name,count_rating,agency_score in that i want those records which are not rated. i try this query but not working
SELECT * FROM agency_rating RIGHT JOIN agency_registration
ON agency_registration.agency_id=agency_rating.agency_id order by agency_registration.agency_id
Subject
Views
Written By
Posted
44130
December 04, 2007 01:55PM
16248
December 04, 2007 07:59PM
16355
December 05, 2007 05:53AM
16919
December 05, 2007 07:35PM
select joins from two table in mysql
14292
April 14, 2008 10:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.