Hi guys and gals.

I've got PHPMyAdmin installed and can browse my database.

I would like to run a query on it though, and am a bit of a thickie. I want the query to return a list of orders for each manufacturer. I only have two manufacturers at present. (We'll call one of the Microsoft)

The query therefore needs to be be like this:

select * from 'orders' where manufacturer is 'microsoft'

Now that won't work, because I'm stupid, and the manufacturer doesn't even appear in orders table.....

So, can someone tell me how the syntax for this cross-table query should actually be written.

Once I've got the query then I've worked out how to export the results to Excel.

Many thanks.