SQL statement – inner join

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

November 11th, 2008 | Tags: | Category: 電腦 | Leave a comment

SQL statement ordering

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 a SQL [...]

November 9th, 2008 | Tags: | Category: 電腦 | Leave a comment