"`SELECT (SELECT TOP 1) FROM` is not supported by Jet."
---
"Can be supported after rearranging CROSS JOIN/JOIN expressions."

Currently, the following SQL is generated:

SELECT
FROM (`Orders` AS `o`,
`Orders` AS `o0`)
LEFT JOIN `Customers` AS `c` ON `o`.`CustomerID` = `c`.`CustomerID`)
LEFT JOIN `Customers` AS `c0` ON `o0`.`CustomerID` = `c0`.`CustomerID`

However, the following SQL is needed for Access to understand the query:

SELECT
FROM Orders AS o
LEFT JOIN Customers AS c ON o.CustomerID = c.CustomerID,
Orders AS o0
LEFT JOIN Customers AS c0 ON o0.CustomerID = c0.CustomerID

The same is true for INNER JOINs as well.
---


[Fact(Skip = "Probably unsupported by JET")]
[Fact(Skip = "Unsupported by JET")]
[Fact(Skip = "Unsupported by JET: subqueries supported only in FROM clause")]
[Fact(Skip = "Unsupported by JET: SELECT TOP 2 (SELECT TOP 1) returns 2 records")]
[Fact(Skip = "Unsupported by JET: SELECT ORDER BY (SELECT)")]
[Fact(Skip = "Unsupported by JET: SKIP TAKE is supported only in outer queries")]
[Fact(Skip = "Unsupported by JET: too complex query with DUAL")]
[Fact(Skip = "Unsupported by JET: DateTime does not support milliseconds")]
[Fact(Skip = "Unsupported by JET: SKIP TAKE DISTINCT")]
[Fact(Skip = "Assertion failed without evident reason")]
[Fact(Skip = "Unsupported by JET: Guid are supported indirectly")]
[Fact(Skip = "Unsupported by JET: Should be implemented by provider")]
[Fact(Skip = "Unsupported by JET: DateTimeOffset not fully supported")]
[Fact(Skip = "Unsupported by JET: CROSS JOIN and OTHER JOIN")]
[Fact(Skip = "Unsupported by JET: JOIN with unsupported ON PREDICATE")]
[Fact(Skip = "Unsupported by JET: operators on IMAGE and TEXT data types are not supported")]
[Fact(Skip = "Unsupported by JET: Data type unsupported")]
[Fact(Skip = "Unsupported by JET: rowversion unsupported")]
[Fact(Skip = "Unsupported by JET: nullable bit not supported")]
[Fact(Skip = "Unsupported by JET: JET behaviour requires that both columns in a composite foreign key are null")]
[Fact(Skip = "Unsupported by JET: OleDB does not support parallel transactions")]