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

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 | <----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 )? if so, i guess there would be some performance benefit.

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

[Reply to this message]