query question

[justinh]

trying to pull data from multiple tables and am having some trouble

 

<?php 

$query = "

SELECT 

hrclienta.cl_firstname, 

hrclienta.cl_lastname,

    hrhunts.dateofhunt, 
   
    hrhunts.totalcost,

    hrhunts.paidstatus 

    FROM 

    hrclienta, 
   
    hrhunts, 

    WHERE 

    (hrclienta.cl_partyid = hrhunts.huntid AND hrclienta.cl_partycontact = 'y')";


    $doit = mysql_query($query) or die(mysql_error()); 

     ?>

 

This gives an error of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (hrclienta.cl_partyid = hrhunts.huntid AND hrclienta.cl_partyconta' at line 19

 

Not sure what I'm doing wrong, Thanks in advance

[premiso]

Extra comma:

 

    hrclienta, 
   
    hrhunts // removed comma here.