SELECT id, name, createtime
FROM pre_tamplate AS tamplate
JOIN pre_table AS table
WHERE tamplate.id = table.id
AND table.id = 1234;
SELECT id, name, createtime
FROM pre_tamplate AS tamplate
JOIN pre_table AS table
WHERE tamplate.id = table.id
AND table.id = 1234;
SELECT id, name, createtime
FROM pre_tamplate AS tamplate
JOIN pre_table AS table
WHERE tamplate.id = table.id
AND table.id = 1234;
SELECT
id,
name,
createtime
FROM
pre_tamplate AS tamplate
JOIN
pre_table AS table
WHERE
tamplate.id = table.id
AND table.id = 1234;