select over 2 Tables

[Determ]

Moin Moin dr. Friends
a little Question:

MySQL:
Test -> USteel, and other
Norm -> ASTM, ISO, and other

Php: * stay for C, Mn, Si, and other
Select * from USteel, with 2 or 3 Subselect
Select * from ASTM, with 2 or 3 Subselect



all Selects work fine under WOS, XAMP or Uniform-Server.
The Selects work alone.

but what can I do for this:

while ($row = mysql_fetch_object(*))

for USteel I have a while and for ASTM too, but i think they can maybe work togehter.
Here I have (Newbie) some Problems with the Answer.

I wish/think in this Form:


$row->ASTM from Norm
$row->C from Test

in 1 Select with some Subselects

Sincelery
Determ