I have a Crystal Report connected to a SQL database via an ODBC SQL Server connection. There is a field from this database that I'm trying to retrieve using the SQL Expression below. It does not appear to work as it causes the report to "timeout" and hang up with the status bar continually displaying "accessing database". I'm not sure if the syntax is correct. It is a very convoluted path as there are multiple table that have to link in order to pull the correct piece of data.

I'm dropping this in a group footer. Have been stuck on this issue for days, and it's the last piece I need to complete my report. Any assistance would be GREATLY appreciated.

(
SELECT
MIN(SalesOrderDeliveries.omdDeliveryDate)
FROM dbo.Jobs
INNER JOIN dbo.SalesOrderJobLinks
ON "Jobs"."jmpJobID" = "SalesOrderJobLinks"."omjJobID"
INNER JOIN dbo.SalesOrders
ON "SalesOrderJobLinks"."omjSalesOrderID" = "SalesOrders"."ompSalesOrderID"
INNER JOIN dbo.SalesOrderLines
ON "SalesOrders"."ompSalesOrderID" = "SalesOrderLines"."omlSalesOrderID"
INNER JOIN dbo.SalesOrderDeliveries
ON "SalesOrderLines"."omlSalesOrderID" = "SalesOrderDeliveries"."omdSalesOrderID"
WHERE "SalesOrderDeliveries"."omdShippedComplete" = 0
)