I need to match hardware to windows. There are two suitable hardware types for each window, and many sizes of each. I have a working query for each hardware type. They select the hardware size based on the weight and height of the window. The ranges are not the same between the two, so one window may only appear in the type A query, while another may only appear in the type B query. I would like to incorporate them into a single query that makes a choice between the two hardware types. Select type A for all windows that appear in both queries, and the appropriate type for windows that appear only in one query or the other.
A LEFT JOIN selects all A's and those that can use A or B. A RIGHT JOIN selects the converse.
How do I select all A's with no matching B's AND all B's with no matching A's, as well as those that have A's and B's?
Thanks in advance.
A LEFT JOIN selects all A's and those that can use A or B. A RIGHT JOIN selects the converse.
How do I select all A's with no matching B's AND all B's with no matching A's, as well as those that have A's and B's?
Thanks in advance.