Skip navigation links

MySQL Forums :: Ruby :: avg () and Joins in mysql


Advanced Search

avg () and Joins in mysql
Posted by: Erfan anjum ()
Date: May 24, 2010 12:22PM

hi,

i am using following query to fetch data from multiple tables now i want to get the average of fetched records.
like i want to get the average marks of IRFAN.

CAN ANYONE PLS TELL ME HOW TO USE AVG() IN THIS QUERY




$QUERY = "SELECT subject,FirstName,marks FROM subject,all_members,marks WHERE all_members.mid = marks.mid and subject.subjectid = marks.subjectid and marks>=40 and all_members.FirstName='irfan'";
$rs = mysql_query($QUERY);

Options: ReplyQuote


Subject Written By Posted
avg () and Joins in mysql Erfan anjum 05/24/2010 12:22PM


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.