php select multiple tables from mysql

[tommy445]

Hello,

 

I am trying to select data from multiple tables with no like fields.

 

this is my code:

$sel = "select * from clients, lenders where client_id='".$_POST['client_id']."'";

 

When I only select from table clients, I get a print out of one record which is right.  However when I select from both tables, I get printouts of the record i want but also printouts of each record in the lenders table.

 

My printout should only be one record.  The one with the client_id.

 

Final Note, I have an html form where I input the client id which sends to the php page.  I'm new to this so I hop my explanation is ok.