Posted by newbie on 07/22/07 18:52

--------------------------------------------------------- table_info
| id | age | first_name | last_name |
---------------------------------------------------------
| 10 | 21 | tom | ben |
---------------------------------------------------------

---------------------------------------------------------
table_working_hr
| id | coming_date | work_hour |
---------------------------------------------------------
10 | 12 | 4 |
---------------------------------------------------------
10 | 11 | 4 |
---------------------------------------------------------
10 | 22 | 6 | <-------the
will be the final result.
---------------------------------------------------------


$result= mysql_query(" select * from table_info where first_name =
'tom' ");
$id = $result['id'];
mysql_query(" select * from table_working_hr where id='$id' AND
coming_date > 20 ");

Can I get the result with a single query (with some advanced query
like join )?

• Next in forum: a single query to achieve two sequential ones, is it possible?
• Prev in forum: Re: Using a Resource as a Class Property
• Thread view: how to have these two consequent queries become a single one by 'join' in mysql

[Reply to this message]