Posted by ZeldorBlat on 07/22/07 19:33

On Jul 22, 2:56 pm, newbie <mitbb...@yahoo.com> wrote:
> 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

[Back to original message]