[SOLVED] SQL Query

[RAH]

Hi,

 

I have the following SQL query:

 

SELECT * FROM file_items ORDER BY view DESC LIMIT 0, 1

 

This lists the top viewed file in the database.  However there's a problem with this.

 

I need to ensure that file is of a certain type.  In a seperate table named "files" there is a column named "type".  The above query needs to be modified so that these two tables are cross-referenced.  Both tables have a column named "id" which could be used to match things up.

 

I'm not quite sure how to go about this - all help would be greatly appreciated.

 

Thanks.

[js_280]

SELECT * FROM file_items LEFT JOIN files ON file_items.id = files.id WHERE files.type = "needed type here" ORDER BY file_items.view DESC LIMIT 0, 1