hi all, I would like to ask if this is a good way to merge two databases into one?

library(TCGAbiolinks)

query1 <- GDCquery( project = "TCGA-COAD", data.category = "Simple Nucleotide Variation", data.type = "Masked Somatic Mutation", legacy=F)

muts <- GDCprepare(query1)

clin <- GDCquery_clinic("TCGA-COAD","clinical")

library(tidyverse) library(stringr)

muts$bcr_patient_barcode <- str_sub(muts$Tumor_Sample_Barcode, 1, 12)

mut2 <- left_join(muts, clin, by = c("bcr_patient_barcode"))

Thanks :)