How do I write the following query in JET SQL?
If PMOS In ("11b","11c","11d","11f" then PMOS = "11"
If PMOS In ("12b","12c","12d","12f" then PMOS = "12"
If PMOS In ("13b","13c","13d","13f" then PMOS = "13"
If PMOS In ("45b","45c","45d","45f" then PMOS = "45"
IF PMOS Not In ("11b","11c","11d","11f", "12b", "12c",
"12d","12f", "13b","13c","13d","13f","45b","45c","45","45f"then PMOS = "OTHER";
If PMOS In ("11b","11c","11d","11f" then PMOS = "11"
If PMOS In ("12b","12c","12d","12f" then PMOS = "12"
If PMOS In ("13b","13c","13d","13f" then PMOS = "13"
If PMOS In ("45b","45c","45d","45f" then PMOS = "45"
IF PMOS Not In ("11b","11c","11d","11f", "12b", "12c",
"12d","12f", "13b","13c","13d","13f","45b","45c","45","45f"then PMOS = "OTHER";