I am attempting to join two tables by two common columns. The columns are named AD_TYPE and GRP_FDC. The tables are named tbl_FDC tbl_CLASSIFIED.
In the tbl_FDC there are a series of AD_TYPEs with the advert type zz. With a corresponding GRP_FDC, typically OTH, BMD, ETC. I have a problem in that the only fields that differentiates that values are fields named CLASS_UPPER and CLASS_LOWER which contain a range for the values? At present when I execute the query I am getting multiple invalid rows because the query cannot distinguish which CATEGORY it should allocate. Is there any way I can create a calculated column that is able to distinguish between the two? I have attached a screen dump of the tables.
Thanks,
In the tbl_FDC there are a series of AD_TYPEs with the advert type zz. With a corresponding GRP_FDC, typically OTH, BMD, ETC. I have a problem in that the only fields that differentiates that values are fields named CLASS_UPPER and CLASS_LOWER which contain a range for the values? At present when I execute the query I am getting multiple invalid rows because the query cannot distinguish which CATEGORY it should allocate. Is there any way I can create a calculated column that is able to distinguish between the two? I have attached a screen dump of the tables.
Thanks,
