Hoping someone can help me with this. I would like to see how to join/display table info via a couple of fields from multiple tables. Short version is I need the Table B gen_name field to generate based on the matching model_id fields ..... IF the Table A model_year is between the gen_start_year and gen_end_year.
example: IF (model_year >= gen_start_year & <= gen_end_year, display gen_name)
Table A:
LOAD
model_id,
model_year,
etc....
FROM ...
Table B:
LOAD
model_id,
gen_start_year,
gen_end_year,
gen_name
FROM ...
I'm assuming that this process would be best performed in the load editor and I would appreciate seeing what that may look like. I'm still a little unsure where to put additional scripts in the editor so if you could show what the entire script (tables & all) looks like, that would really help me out.
