How can I do a join in QuerySpec to a table with composite key fields? For example, a table that has a foreign key reference to Northwind Order Details.
I've tried this (with & and also with && operators) but it doesn't compile.
var query = qf.Create()
.From(qf.OrderDetaill)
.InnerJoin(qf.OrderDetailChild)
.On(OrderDetailFields.OrderId == OrderDetailChildFields.OrderId &
OrderDetailChild.ProductId == OrderDetailChildFields.ProductId
Surely there must be a way to do this.