bucks-community-assets-export

query.sql

SELECT ASSETS.[Asset ID], ASSETS.[GET category], ASSETS.KeyWords, ASSETS.ACMD, ASSETS.CR, ASSETS.DO, ASSETS.EL, ASSETS.SG, ASSETS.SCG, ASSETS.SA, ASSETS.YPA, ASSETS.[Local Area], ASSETS.Area, ASSETS.Organisation, ASSETS.Meeting, ASSETS.MO, ASSETS.TU, ASSETS.WE, ASSETS.TH, ASSETS.FR, ASSETS.ST, ASSETS.SU, ASSETS.DaytimeMeetings, ASSETS.[Time-Date], ASSETS.Venue, ASSETS.Postcode, ASSETS.Cost, ASSETS.ContactName, ASSETS.ContactNo, ASSETS.Website, ASSETS.ContactEmail, ASSETS.Description, ASSETS.[Last-Updated], ASSETS.ReviewDate, ASSETS.[Status-of-Review], ASSETS.[Review Notes], ASSETS.Assigned, ASSETS.ReviewNumber, [Page 2].[Age YP], [Page 2].[Age YA], [Page 2].[Age OA], [Page 2].[Local Area], [Page 2].[LAF GAyl], [Page 2].[LAF Wadd], [Page 2].[LAF C&CV], [Page 2].[LAF Beec], [Page 2].[LAF W&D], [Page 2].[LAF NWC], [Page 2].[LAF GBWI], [Page 2].[LAF H&LC], [Page 2].[LAF SWC&M], [Page 2].[LAF Amer], [Page 2].[LAF Buck], [Page 2].[LAF HW], [Page 2].[LAF W&I], [Page 2].[LAF CWV], [Page 2].[LAF Chal], [Page 2].[LAF Wend], [Page 2].[LAF Beac], [Page 2].[LAF D&GX], [Page 2].[LAF Miss], [Page 2].[LAF Quar], [Page 2].CondAutism, [Page 2].CondDementia, [Page 2].[Cond Learn], [Page 2].CondMH, [Page 2].CondOP, [Page 2].CondDisability, [Page 2].CondHearVisual, [Page 2].VolunteerDBS, [Page 2].Safeguarding, [Page 2].[H&S], [Page 2].Insurance, [Page 2].Accessibility, [Page 2].[CLO Notes], [LAF areas].[LAF areas], [CCG Areas].[CCG Locality], ReviewStatus.Status
FROM ReviewStatus RIGHT JOIN ([CCG Areas] RIGHT JOIN ([LAF areas] RIGHT JOIN (ASSETS INNER JOIN [Page 2] ON ASSETS.[Asset ID] = [Page 2].[Asset ID]) ON [LAF areas].ID = ASSETS.[LAF area]) ON [CCG Areas].ID = ASSETS.[CCG list]) ON ReviewStatus.ID = ASSETS.[Status-of-Review];