in reply to 2 mysql selects in one statement
You need to JOIN the tables together somehow. What's their relationship? How do you know that a particular row in one table corresponds to a row in the other table? Without knowing that, it's likely that your information will be incorrect in subtle ways.
Once you answer that question, it'll be easier to demonstrate how to SELECT from multiple tables.
|
|---|