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 = '';
|
