Sending column from sub query

Question

There are two tables one transaction and other customer. I am getting multiple rows of customerid and service time, but I want customer name (which is in customer table) and service time. So I tried below query which is not working.

select name,service_time from CUSTOMER,TRANSACTION
WHERE id IN 
(
    select customer_id,service_time from TRANSACTION 
    where  service_date='$date' and employee_id='$employee_id'
);

In what way is it not working? Can you clarify your first sentence. — Bill Woodger, Aug 21 '15 at 11:22
@bill i want to use service_time which i fetched from subquery along with name.@ullas because i want both — rohan, Aug 21 '15 at 11:28

score 0 · Accepted Answer · edited May 23 '17 at 11:58

0

Use JOIN

SELECT c.name, t.service_time 
  FROM CUSTOMER AS c
  JOIN TRANSACTION AS t ON t.customer_id = c.id
 WHERE t.service_date = '$date' 
   AND employee_id = '$employee_id'

Refer to:

edited May 23 '17 at 11:58

Community

1
1

answered Aug 21 '15 at 11:35

Ravinder Reddy

23,692
6
52
82

Sending column from sub query

1 Answers1