Extract information from Identifiers (CG02)

[imachoshvili]

Hello everyone,

I have a list of substances created in CG02 and these substances have several lines in Identifiers tab, filled with diverse information.

Each line could or could not have USAGE information.

Is it possible to extract information from USAGE based on a list of substances? I need to check ValAreaCat and Validity Area as shown below in the red square.

Thanks.

Igor

[holger_hartung]

Hi,

you could join table ESTRH and ESTRI to extract information.