SELECT COUNT(a.adview_id) FROM {adviews} a JOIN {joblist} j
WHERE j.advid = '1'

But that doesnt seem to work. What is the best way to do this?

CREATE TABLE IF NOT EXISTS {joblist} (
jobid INT(10) NOT NULL AUTO_INCREMENT,
advid INT(10) NOT NULL DEFAULT 0,
PRIMARY KEY jobid (jobid))

CREATE TABLE IF NOT EXISTS {advertisers} (
advid INT(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY advid (advid))

CREATE TABLE IF NOT EXISTS {adviews} (
adview_id BIGINT NOT NULL AUTO_INCREMENT,
jobid INT(10) NOT NULL,
referer VARCHAR(250) NOT NULL DEFAULT '',
browser_ip VARCHAR(15) NOT NULL DEFAULT '',
datecreated INT(11) NOT NULL DEFAULT 0,
uri VARCHAR(250) NOT NULL DEFAULT '',
username VARCHAR(96) NOT NULL DEFAULT '',
PRIMARY KEY (adview_id)}