compose table and check the values inside

[Anonymous]

Hi guys,

          I've n table, with n from 1 to 10, every table contains the same field:

• id_code
• date (MM/YYYY)
• status

and I would make this action in this order:

1. I would load the values from the first table ;
2. I would load the values from the next table only if

              id_cod and data and status aren't loaded before (note: and like logical operator)

I would repeat the second point from 2-table to n-table.

Furthermore sometimes there may be an error, and the value of field status inside a triple could be '-'

          for example: x234y, -, 04/2017

    so if so it is happened and in the next table I find the right triple

          for example: x234y, active, 04/2017

I would delete the old triple and add the new.

Is this possible?

I hope I have been clear

Thank you!!!

[vinieme12]

what if the earlier table had the row

          for example: x234y, active, 04/2017

and in the next table

          for example: x234y, -, 04/2017

What then ?

[Anonymous]

at the second step should be the check, on your example

id_code	status	date
x234y	-	04/2017
false (there is)	true (there isn't)	false (there is)

so the triple should be discarded