SELECT *,t2.col_name, t3.col_name
FROM table1 t1
LEFT JOIN table2 t2
ON t1.col_name=t2.col_name
LEFT JOIN table3 t3
ON t1.col_name=t3.col_name
Saturday, May 4, 2013
Multiple Left joins example
SELECT *,t2.col_name, t3.col_name
FROM table1 t1
LEFT JOIN table2 t2
ON t1.col_name=t2.col_name
LEFT JOIN table3 t3
ON t1.col_name=t3.col_name
Print using javascript
<html>
<body>
<input type="button" value="click" onclick="printDiv()">
<div id="divToPrint">hello</div>
</body>
</html>
<script>
function printDiv()
{
var divToPrint=document.getElementById('divToPrint');
var newWin=window.open('','Print-Window','width=100,height=100');
//alert(divToPrint.innerHtml);
newWin.document.open();
newWin.document.write('<html><body>'+divToPrint.innerHTML+'</body></html>');
window.print()
//newWin.document.close();
//setTimeout(function(){newWin.close();},10);
}
</script>
<body>
<input type="button" value="click" onclick="printDiv()">
<div id="divToPrint">hello</div>
</body>
</html>
<script>
function printDiv()
{
var divToPrint=document.getElementById('divToPrint');
var newWin=window.open('','Print-Window','width=100,height=100');
//alert(divToPrint.innerHtml);
newWin.document.open();
newWin.document.write('<html><body>'+divToPrint.innerHTML+'</body></html>');
window.print()
//newWin.document.close();
//setTimeout(function(){newWin.close();},10);
}
</script>
Subscribe to:
Comments (Atom)