The query below using INNER JOIN works and delivers the results I want..
Code: Select all
$result = mysql_query
("SELECT cm.id, cm.date, cm.name, cm.location, cm.city, cm.status, cm.discipline, cm.CV, cm.interested
FROM cm
INNER JOIN app
ON cm.id = app.ap_id
INNER JOIN joblist
ON joblist.id = app.apjob_id
WHERE joblist.location like '$loc' AND cm.location NOT like '$loc'
") ;
Code: Select all
$result = mysql_query
("INSERT INTO cs (cs.cid, cs.date, cs.name, cs.location, cs.city, cs.status, cs.discipline,cs.CV, cs.interested)
SELECT cm.id, cm.date, cm.name, cm.location, cm.city, cm.status, cm.discipline, cm.CV, cm.interested
FROM cm
INNER JOIN app
ON cm.id = app.ap_id
INNER JOIN joblist
ON joblist.id = app.apjob_id
WHERE joblist.location like '$loc' AND cm.location NOT like '$loc'
") ;
Again, many thanks in advance.
Chris