Minta tolong menampilkan semua data dengan 1 user dengan 2 jaminan di 2 tabel

<a href='https://drive.google.com/open?id=1hj7hge_Q1bGGHlDsBnq-29l1WzGW4EsS'>hasil output nya seperti ini</a>

<a href='https://drive.google.com/open?id=1PB8hO_nR4ZHW-vep_GDnuN-b3co0gDV9'>inginnya hansilnya seperti ini</a>

Minta bantuannya para master... Sudah coba utak atik masih tetep

<?php
		include ("koneksi.php");
		$rowasi = mysql_query("SELECT * FROM data_identitas");
		$row=mysql_fetch_array($rowasi);
		$kode_deb = $row['kode_deb'];

		$q = "SELECT data_identitas.nama_su, data_identitas.kode_deb, data_jaminan_shm.jenis_sertifikat FROM data_identitas,data_jaminan_shm WHERE data_identitas.kode_deb=data_jaminan_shm.kode_deb"; //query to get the search result
		$result = mysql_query($q); //execute the query $q
		$i = 1;
		while ($rows = mysql_fetch_array($result)) {  //fetch the result from query into an array
echo "			<tr>
					<td>$i</td>
					<td bgcolor='#D7F0FF' class='upper valign='top'>$rows[nama_su]</td>
					<td bgcolor='#ECFDFA' class='upper' valign='top'></td>
					<td bgcolor='#ECFDFA' class='upper' valign='top'></td>
			</tr>
			<tr>
					<td></td>
					<td bgcolor='#D7F0FF' align='center' valign='top'>$i</td>
					<td bgcolor='#ECFDFA' class='upper' valign='top'>$rows[kode_deb]</td>
					<td bgcolor='#ECFDFA' class='upper' valign='top'>$rows[jenis_sertifikat]</td>
			</tr>
		";
		?>
		<?php ;$i++;}?>
		<tr>

}
<?php echo   "</tr>
</table>";

?>