SQL

Start Here Glossary WHERE INSERT (Create) SELECT (Read) UPDATE DELETE Join Tables Sub Query Limit Records SQL Injection SSMS Meta Data Sum TABLE Apostrophe Date Identity
O O

Weather Controls

Time Of Day
Rain
Wind Speed
Wind Direction
Clouds

SQL : Join Tables

2017-12-19

Join 2 (or more) tables together. LEFT JOIN is most commonly used method.

SELECT TOP 10 
wiki_wiki.wikiID, wiki_wiki.name, wiki_wiki.bodyID, wiki_wiki.categoryID, wiki_wiki.modifiedDate, --columns from base table
wiki_category.name AS categoryName --column from joined table with alias name
FROM wiki_wiki --base table
LEFT JOIN wiki_category on wiki_category.categoryID = wiki_wiki.categoryID --the join
ORDER BY modifiedDate DESC --now order it newest