Question: GEOmetadb urgent question!
gravatar for vasco.cluny
3.7 years ago by
vasco.cluny0 wrote:

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,",
                            "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  




geometadb R • 526 views
ADD COMMENTlink modified 3.7 years ago by James W. MacDonald51k • written 3.7 years ago by vasco.cluny0
Answer: GEOmetadb urgent question!
gravatar for James W. MacDonald
3.7 years ago by
United States
James W. MacDonald51k wrote:

This isn't a Bioconductor question, but is really a general SQL question. You are asking 'what is an inner join in SQL', which you could use as a Google query to get more information.

The basic idea is that you have two tables in a database, and you want to get data from both tables. The inner join (in SQLite 'join' is the same as 'inner join') is the same as the merge function in R, where you are combining two tables based on columns in each table, and then selecting rows from the resulting table. An inner join forces the constraint that the values being merged on must be found in both tables.

ADD COMMENTlink written 3.7 years ago by James W. MacDonald51k
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 133 users visited in the last hour