Ars Technica

SQL three table join - how to thin the result set.

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 ...
Ars Technica

[SQL] Need help forming SQL query for Inner Join via OleDB (MS Access)

I'm writing some code in C# where I need to (inner?) join two tables into a DataSet / DataTable.<BR><BR>Essentially, I have two tables. Both have columns called "TestId" and "OperationId". Both are ...