I have searched for hours and have not completely understood this or something. I am needing to Concatenate Field Strings Together From 2 Separate Tables Into One Field caled ProdConSku.
Tables are called SKUs and Products
The Fields are SKU in the SKUs Table and ConditionID in the Products Table.
Say CSGWJ77Q9B4 was in the SKU field in the SKUs table
NSOP was in the ConditionID field in the Products table.
I want it to say CSGWJ77Q9B4NSOP in the ProdConSku field in the Products table.
I have gotten close with the SELECT Query but not combined into one field. Thank you!