Hai folks,

Code:
	
$query="SELECT * FROM candidates INNER JOIN approvals 
			ON candidates.cid = approvals.cid 
			WHERE agency_code='$agency_code'
			
			UNION
			
            SELECT * FROM candidates_ans INNER JOIN approvals_ans 
			ON candidates_ans.cid = approvals_ans.cid 
			WHERE agency_code='$agency_code'";

if ($result=mysql_query($query) or die (mysql_error()));
while ($row=mysql_fetch_array($result)){

xxxxxx

}
I want to know the table name currently the while loop is fetching records