Ars Technica

T-SQL INNER JOIN on IF statement

I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.
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 ...
Visual Studio Magazine

Leverage Joins in Entity Framework To Get Just the Data You Want

Let's say, for example, that you want to retrieve all of the SalesOrderDetails for SalesOrders that have a delivery date in the future. You could write this query to follow the SalesOrderDetail ...