IPC NACE2 Concordance "not with ipc"
Posted: Thu Dec 17, 2015 11:46 am
Dear PATSTAT users and experts,
I am trying to query the industries for each application id, i.e. tls209_appln_ipc with tls902_ipc_nace2 joined on ipc%.
I know that there is a table tls_appln_nace2 where this is already done, but I want to know how to include the "not_with_ipc", "unless_with_ipc" columns in the basic query to assign the industries to applications. I have no idea how to do that.
I also would like to know how to calculate the weights in my query including these additional constraints ("not_with_ipc" ...).
I am asking because I uploaded a further table from OECD where I have an additional column "only together_with_ipc". With this constraint, I do not know how to write the query in order to take all columns into account when joining with applications (I also join on ipc%).
I also would like to calculate weights taking account this additional constraint.
Any help is appreciated.
Florian
I am trying to query the industries for each application id, i.e. tls209_appln_ipc with tls902_ipc_nace2 joined on ipc%.
I know that there is a table tls_appln_nace2 where this is already done, but I want to know how to include the "not_with_ipc", "unless_with_ipc" columns in the basic query to assign the industries to applications. I have no idea how to do that.
I also would like to know how to calculate the weights in my query including these additional constraints ("not_with_ipc" ...).
I am asking because I uploaded a further table from OECD where I have an additional column "only together_with_ipc". With this constraint, I do not know how to write the query in order to take all columns into account when joining with applications (I also join on ipc%).
I also would like to calculate weights taking account this additional constraint.
Any help is appreciated.
Florian