Select 2 Tables

[phpretard]

Is it possable to select 2 tables with the same query?

 

I would like to combine the two statements.

 

mysql_query("SELECT * FROM members WHERE CNumber='$CNumber' ");

mysql_query("SELECT * FROM readings WHERE CNumber='$CNumber' AND RType='$RType'");

 

 

Thank you.

[soycharliente]

Is it possable to select 2 tables with the same query?

 

I would like to combine the two statements.

 

mysql_query("SELECT * FROM members WHERE CNumber='$CNumber' ");

mysql_query("SELECT * FROM readings WHERE CNumber='$CNumber' AND RType='$RType'");

 

Thank you.

 

Is CNumber the same thing in both tables?

[wildteen88]

Use a JOIN:

SELECT * FROM members m, readings r WHERE m.CNumber='$CNumber' AND r.CNumber='$CNumber' AND r.RType='$RType'"

[phpretard]

Yes it is...but the $RType is only in one of the tables.  I need both though.

[soycharliente]

SELECT * FROM members m JOIN readings r ON m.CNumber=r.CNumber WHERE r.RType='$RType'

 

That the same thing as yours wild?

[phpretard]

Thank a million!!!

 

The solved button is still gone??