SQL query

[bschwarz]

I want to get data from two tables at once.

Something like..

SELECT tblA.fieldA, tlbB.fieldC FROM tblA WHERE status = 'CURRENT' JOIN = 'prefix' 

Basically I want to pull a few fields, from two different tables that share the same "prefix" and thier status' = 'current'

[bschwarz]

query currently looks like this :

$query = "SELECT project_list.prefix, project_list.project_number, project_list.project_type, project_list.description, project_list.status, client_list.client_name FROM project_list LEFT JOIN client_list ON project_list.prefix=client_list.prefix WHERE status = 'Current'";

[bschwarz]

actually I want to be able to update all of these fields based on user input after that select query is displayed.

how could that be done also?