How can I populate datagrid with a table join / 2 tables ?

[jarmanje]

Hi there,

I have 2 tables i'd like to get info from:

Products:
ProductID
Price
Stock

ProductOrdered:
OrderID
ProductID
quantity
ColourID

At the moment, i populate my datagrid by using the 'build application...' built into flex. But this only creates an app that edits one table at a time.

How would i be able to load info from 2 tables into a flex grid? If i was going to use flash as3, would use an sql in the php like this:

$sql = "SELECT `Products `. Price, `ProductOrdered `.* FROM `Products `, `ProductOrdered ` WHERE `ProductOrdered `. ProductID = `Products `. ProductID;

I'm new to flex, but learning how to read from the php scripts generated in flex. But this is a bit confusing how i would do this..