By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,567 Members | 1,670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,567 IT Pros & Developers. It's quick & easy.

a single query to achieve two sequential ones, is it possible?

P: n/a
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.

Jul 22 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Jul 22, 2:56 pm, newbie <mitbb...@yahoo.comwrote:
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.
select i.id, i.age, i.first_name, i.last_name,
w.coming_date, w.work_hour
from table_info i
join table_working_hr w
on i.id = w.id
where i.first_name = 'tom'
and w.coming_date 20

Jul 22 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.