DataBase - SQL Server SQL to Access 2003

Asked By Geossl

08-Oct-09 10:19 PM

The following query is for SQL Server. How to convert this to Access 2003 SQL?

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

09-Oct-09 03:29 AM

hi,

The cross join is the simple: .. FROM Organization, Item...


mfG
--> stefan <--

09-Oct-09 04:46 AM

But the whole thing does not work...

09-Oct-09 04:56 AM

hi,

Sorry, I thought it was obvious that you need another sub select, e.g.

SELECT *
FROM
(
SELECT T1.Id AS T1ID,
T2.ID AS T2ID
FROM Table1 T1, Table2 T2
) Q
LEFT JOIN (
SELECT *
FROM Table3 T3
) AL ON AL.ID = Q.T1Id AND AL.ID = Q.T2Id



mfG
--> stefan <--

09-Nov-09 10:16 PM

It works.... Thanks.