清心小棧

Today still hammering on SQL statement. As a beginner, I surely got problems on that. I just want to share the SQL syntax to beginner like me.

SELECT [Table1].[Field], [Table2].[Field] FROM [Table1] INNER JOIN [Table2] ON [Table1].[Key Field]=[Table2].[Key Field]
WHERE
GROUP BY
ORDER BY

Recently, I’ve got a small task on creating a SQL enquiry statement. As a beginner, it’s still a easy thing to complete a statement, but it returns a error to me. I asked google about the error, after a while I understand the reason about the error message.

It has a style to complete [...]