enlacee/inner-join.sql

## inner-join.sql
/**
* Sql indicator only exist data in c_tool
* if true make join success.
* ------------------------------
* SQL inner join fuera de lo normal
*/

SELECT t.* FROM c_tool t
INNER JOIN (
    SELECT c_id, MAX(id) as id
    FROM c_tool
    GROUP BY c_id
) tmp ON tmp.c_id = t.c_id AND tmp.id = t.id;
	/**
	* Sql indicator only exist data in c_tool
	* if true make join success.
	* ------------------------------
	* SQL inner join fuera de lo normal
	*/

	SELECT t.* FROM c_tool t
	INNER JOIN (
	SELECT c_id, MAX(id) as id
	FROM c_tool
	GROUP BY c_id
	) tmp ON tmp.c_id = t.c_id AND tmp.id = t.id;