inner join id php code example

Example: inner join in php

<?php
SELECT t1.*, t2.subject, t2.color FROM questionoftheday t1 INNER JOIN subject t2 
ON t1.sid = t2.ID WHERE t1.qdate='$newrd' AND t1.status='1' ORDER BY t1.ID DESC
?>