Ask Your Question

Base crash on union sql

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

axeljclark 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 +0100

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 +0100

Seen: 370 times

Last updated: Mar 18 '16