Hello, all. I am very new to the SQL language. Here’s hoping someone can help with my question.
I am trying to select data from two tables using a column that is in both tables. My question requires a bit of setup.
Table1 has a lot of data in it. For the sake of my question, we’ll call the columns I am interested in as IDTag and ColumnA.
Table2 has its own data in it, but also has the identical IDTag column from Table1. The column I am interested in this table is ColumnB.
ColumnA doesn’t exist in Table2, nor does ColumnB exist in Table1.
My question is…what query do I need to use to select the information in ColumnA and ColumnB using the IDTag column?
Thank you in advance for any help.