Query results from two tables in one field

[charly.csh]

Hello everyone
I have a question regarding about the structure of a query

I have two tables named "Corrective_Actions_tbl" (Fields: ID, Action_txt, Date_Cor, Responsible, Type) and "Containment_Actions_tbl" (Fields: ID, Action_txt, Date_Con, Responsible, Type) each one with the same structure but feeded by different forms

I want to make a general query that contains the results from both



Example in the query:

ID (From table 1 and table 2)
Action_txt (From table 1 and table 2)

and continue in that way

How should it be structured in the query?

Thanks in advance for the support!!

[kd2017]

Are the fields related in a specific way or are you just looking to get the rows of both tables in one query?

https://support.microsoft.com/en-us/...0-ad0a75541c6e

https://support.microsoft.com/en-us/...1-07061a1478f6

[charly.csh]

Just I want to look the rows of both tables in one query, exactly like this

[Gicu]

As shown in the first link use a union query:

SELECT ID, Action_txt, Date_Cor As ActionDate, Responsible, Type, "Corrective_Actions_tbl" As SourceTable FROM Corrective_Actions_tbl
Union
SELECT ID, Action_txt, Date_Con As ActionDate, Responsible, Type, "Containment_Actions_tbl" As SourceTable FROM Containment_Actions_tbl;

Cheers,

[charly.csh]

Hi Gicu
That's exactly what I was looking for!
Just quick question... I am also trying to update data from this query and I cannot write any update any reason why? or how can I fix this?

[moke123]

union queries are not updateable.

[CJ_London]

I don't know anything about your app so there may be good reasons for the structure you have but I would consider stepping back a bit. Combine both tables into one and include an extra column to identify each record as corrective or containment