SELECT from multiple MySQL Tables

offspinner () — Thu, 09 Feb 2006 15:56:12 GMT

// description of your code here



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

;

DZone Snippets: multiple code

SELECT from multiple MySQL Tables