Skip to content

Instantly share code, notes, and snippets.

@mouson
Created January 25, 2019 06:31
Show Gist options
  • Save mouson/a594c60f05a50eb021a8424cb7f33e7b to your computer and use it in GitHub Desktop.
Save mouson/a594c60f05a50eb021a8424cb7f33e7b to your computer and use it in GitHub Desktop.
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment