Hello Guys!I am doing a master thesis but i have a question related to R coding.
I am doing some Geometadb tutorial to understand how it works, and i found this code line that i dont understand totally:
rs <- dbGetQuery(con,paste("select gpl.bioc_package,gsm.gpl,", "gsm,gsm.supplementary_file", "from gsm join gpl on gsm.gpl=gpl.gpl", "where gpl.manufacturer='Affymetrix'", "and gsm.supplementary_file like '%CEL.gz' "))
I dont understand the meaning of the bold part! I need to join the "tables" gsm, gpl, gse and gds to filter some metadata.
Can anyone help me? I would be very greatfull!Thanks in advance