Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 SQL from SQLServer to Access

Author  Topic 

geossl
Yak Posting Veteran

85 Posts

Posted - 2009-10-08 : 02:54:17
Dear All,

How to convert the SQL from MSSQL to Access as following:

SELECT Organization.Name, Organization.Id AS OrganizationID, 
Item.Id as Itemid, Item.CTitle, Item.Title,
AcceptList.*
FROM Organization
CROSS JOIN Item

LEFT JOIN (
SELECT S.OrganizationID, en.ItemID
FROM Event S, Program en
WHERE en.EventID = s.Id
AND en.Accepted = 1
GROUP BY S.OrganizationID, en.ItemID

) AcceptList ON AcceptList.OrganizationID = Organization.Id
and AcceptList.ItemID = Item.Id
where AcceptList.ItemID is null

uie87
Starting Member

2 Posts

Posted - 2009-11-04 : 10:49:38
is this still the bes tway to convert from sql or mysql to access? having issues of course.

hifu - electric mattress pad reviews
Go to Top of Page
   

- Advertisement -