$qs1 = "SELECT a.title as programname FROM node AS a LEFT JOIN node_content_program AS b ON (a.nid = b.nid)
		WHERE a.nid = b.nid AND b.field_series_nid = '300'";

$rval = db_query($qs1);
while ($result = mysql_fetch_object($rval) ) {
$program1 = $result->value;
print $program1;
}