I have a SQL question and was hoping someon can help out. I have two tables with the exact same column headings. What is the most efficienc/effective method (if there is one) of querying for rows from the two separate tables into one data set based upon common data within a single column.
In other words, if tables X and Y both have columns a, b, c and d is it possible to create another table (or query for rows) based on data that appears in, say, column b within both tables?