Quick Search:
 
 mySQL: SELECT from multiple tables. Jump to:  
Category: >> mySQL >> SELECT from multiple tables.  

<< lastnext >>

Snippet Name: SELECT from multiple tables.

Description: SELECT from multiple mySQL tables.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT fulltxt.pqid AS candidate_ft, citations.chid
FROM citations,fulltxt
WHERE citations.issn = fulltxt.issn
AND citations.volume = fulltxt.volume
AND citations.issue = fulltxt.issue
AND citations.YEAR = fulltxt.YEAR
AND citations.spage = fulltxt.spage
AND citations.pqid = ''; 
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org