DISTINCT FROM LEFT JOIN

[jorgeftz]

Hi, I have the follow select where it display like
that using oracle 11g:
M<->Note
1<->2
1<->3
1<->4
2<->8
2<->9

I want to display like that in a html table (M once):
M<->Note
1<->2
"<->3
"<->4
2<->8
"<->9

     $sql = ("SELECT DISTINCT(t1.MIN) AS M, T2.NOTA FROM T1 RIGHT JOIN T2 ON T1.MIN=T2.MIN WHERE (T1.MIN=$list) ");
     $stmt = oci_parse($conn, $sql);
     oci_execute ($stmt);
     while ($row = oci_fetch_assoc($stmt)) {
     $M = $row['M'];
     $NOTA = $row['NOTA'];

}

[Masterblank]

I don't really understand what do you mean by saying (ME once),
but if you want to display results in html table in this manner

    <?
    $output = "";
    $sql = ("SELECT DISTINCT(t1.MIN) AS M, T2.NOTA FROM T1 RIGHT JOIN T2 ON T1.MIN=T2.MIN WHERE (T1.MIN=$list) ");
    $stmt = oci_parse($conn, $sql);
    oci_execute ($stmt);
    while ($row = oci_fetch_assoc($stmt)) {
        $M = $row['M']; // 1
        $NOTA = $row['NOTA'];
        $output .="<tr><td>".$M."</td><td>".$NOTA."</td></tr>\n";
    }
    ?>
<table>
    <tr>
        <th>M</th><th>Note</th>
    </tr>
        <?php echo $output;?>
</table>

[jorgeftz]

Hi, Thanks for reply:

I attached a file. please take a look.