Base crash on union sql

[axeljclark]

I have 29 separate tables of council address data with identical field headers and thousands of entries. I am trying to find an address based on property id that should appear in at least one of the tables. I have been trying to use a union query;

SELECT “ST_NO_FROM”,“STREET”,“ST_TYPE”
FROM “list_address_points_break_o_day”
WHERE “PID” = 6413877
UNION
SELECT “ST_NO_FROM”,“STREET”,“ST_TYPE”
FROM “list_address_points_brighton”
WHERE “PID” = 6413877

Base is crashing every time I try to use this query and requires recovery. Does anyone have any idea why this is happening?

Axel

[Ratslinger]

Aside from the field names, I use an identical Query. The key to making this work is open the Query as ‘Edit in SQL view…’ and on the toolbar is a button labeled ‘SQL’ (Run SQL command directly ). Click this on & save your Query. It should now run.