select datas from firsttable and order by field in secondtable in mysql

select datas from firsttable and order by field in secondtable in mysql

References

Reference NO 1

http://stackoverflow.com/questions/17056145/php-mysql-how-to-select-data-from-two-tables-which-only-first-row-of-second-tabl

Reference NO 2

http://stackoverflow.com/questions/9788006/mysql-order-from-another-table

Reference NO 3

http://dev.mysql.com/doc/refman/5.5/en/select.html

Reference NO 4

http://dev.mysql.com/doc/refman/4.1/en/select.html

Reference NO 5

http://dev.mysql.com/doc/refman/4.1/en/union.html

Reference NO 6

http://tagide.com/blog/2012/08/how-to-handle-large-data-in-mysql/

Reference NO 7

http://www.sitepoint.com/understanding-sql-joins-mysql-database/

Reference NO 8

#EANF#