Any access gurus out there ?
Is the following select too long / complex ? SELECT building.unitary_authority AS UNITARY_AUTHORITY_E, building.national_park AS NATPARK, IIf(building.national_park=-1,community.national_park,Null) AS NATIONALPARKNAME, community.community, building.locality AS LOCAL, building.postcode AS POSTCODE, building.name, building.formerly_listed_as AS FORMALLYLISTEDAS, building.street_number, building.street_side, building.street, building.recno, v_listing.date_listed AS DATELISTED, last_amended.last_amended_date AS DATELASTAMENDED, building.easting AS EASTINGS, building.northing AS NORTHINGS, building.cadwref, v_listing.grade, building.location, v_listing.grouping_description AS description, building_text.history, building_text.reasons AS REASON, building_text.refs AS REFERENCE, building_text.interior, building_text.exterior, community.community_id FROM (((building LEFT JOIN last_amended ON building.full_address = last_amended.full_address) LEFT JOIN community ON building.community = community.community) LEFT JOIN building_text ON building.full_address = building_text.full_address) LEFT JOIN v_listing ON building.full_address = v_listing.full_address WHERE (((building.full_address) In ('Pig & Whistle,,Watton Road,,,,'))); |
I wouldn't have thought so, I assume it does work?
|
That'll be a NO and a YES then ?
|
Nah - Not as expected to work ! It doesn't return the description.
building.cadwref,v_listing.grade,building.location ,v_listing.grouping_description as DESCRIPTION ?? Confused - Oh yes |
Can you send me sample database with the problem query? I'll take a look if that would help
|
All times are GMT +1. The time now is 12:56 PM. |
© 2024 MH Sub I, LLC dba Internet Brands