var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to convert to Access SQL from MSSQL sql
For the following SQL syntax, how to convert to ACCESS 2003 SQL..?
CROSS JOIN Item
LEFT JOIN (
FROM Event, Program
WHERE Event.ID = Program.EventID
AND Event.Accepted = true
) AS List ON List.OrganizationID = OrganizationID
I'd just re-create it in Access... if possible. There would be a fistful of things that SQL Server can do that Jet can't though... "CROSS JOIN" might be one of them.
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "