I have two tables, table_1, and table_2.
I am trying to query both tables, I want every column that is in table_1, and only one column from table_2.
Each table has an AccountID column, so they can relate to eachother.
I am trying to get a query result that gives me all the info from table_1 for each account and also table_2's column that is associated with each account. \
EXAMPLE: table1 has accountID,firstName,lastName
table2 has accountID, middleName.
*I want it to return their firstname,lastname and middle name per account.
Any help or tips would greatly be appreciated. Thanks.