I have three tables. Table 1 has 1 record, and joins to Table 2 on an field called ID which has 5 records. Table 2 joins to Table 3, which has 1 record. The only reason I'm linking in table 2 is ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...