SQL help

I have the following 2 sql strings:

strsql = "SELECT * FROM [tbl_officer_info] WHERE [active_indr]=-1"
strsql = "SELECT * FROM [tbl_other_received] WHERE [active_indr]=-1"

I wish to have them combined so that they take in from bot tables at once and then order by first_name & last_name...

~

SELECT * FROM [tbl_officer_info] WHERE [active_indr]=-1
UNION ALL
SELECT * FROM [tbl_other_received] WHERE [active_indr]=-1
ORDER BY [first name], [last name]

rudy

that doesn't work as the 2 tables have different structures, here is the answer:

strsql =
"SELECT tbl_officer_info.id, tbl_officer_info.first_name, tbl_officer_info.last_name
FROM tbl_officer_info
UNION ALL
SELECT tbl_other_received.id, tbl_other_received.first_name, tbl_other_received.last_name
FROM tbl_other_received
WHERE active_indr=-1
ORDER BY last_name, first_name;"

yeah, UNION [ALL] requires the same structure in both SELECT lists

now you know