SELECT from multiple MySQL Tables
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 = '' ;