So I don't know if it's because I don't know enough terminology or if it hasn't been done, but among the wealth of answers I can't find one that addresses my problem. I have two tables, we'll call them table A and table B. Table A has a foreign key that points to a single row in B. I want to select entries in col1, col2, and col3 of A and add to that selection col4 and col5 from B where the row in A has an id column that points to a row in B. e.g.
I thought this should be easy with an
Use inner join
select a.col1, a.col2, a.col3, b.col1, b.col2 from tableA as a inner join tableB as b on a.b_id = b.id