Ask Your Question

Base crash on union sql

asked 2016-01-14 04:53:36 +0200

axeljclark gravatar image

updated 2020-08-11 23:51:25 +0200

Alex Kemp gravatar image

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?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-18 00:54:30 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-01-14 04:53:36 +0200

Seen: 470 times

Last updated: Mar 18 '16