2 mySQL tables 1 common field

[cosmo7]

I have 2 mySQL tables data1 and data2.
I have a query string for showing me the the records in data2 where the "amount" field is greater than 10.
example:

$sql = mysql_query("SELECT * FROM data2 WHERE amount > 10");

Both tables have a field called "itemnumber" but data1 holds a "description" field.

My question is how do I take the records from my first query ($sql) from data2 and bind them using the itemnumbers to data1 and fetch their description from data1?

Anybody have any ideas?

[remnant]

You can use a join and do it all in one step:

select * from data1,data2 where data2.amount > '10' and data1.itemnumber = data2.itemnumber

[cosmo7]

Thanks alot!
That did the trick.