开发者

retrieving data from multiples tables

hello every one please help me regarding how to make a good query to fetch the data from three table. I am making a database in which there will be users , employee and services which will provided to users via employee so i have set that table name as task. Now i can add the task by fetching the da开发者_如何学Pythonta from different table , the thing right now i want to do is show the entire record by fetching all the client data and services available to him and and who will be going to perform that services . so how can i put the query on the task table to fetch the data from the other table. Thanks

**task table** 
task_id user_id  employee_id    service_id  starttime   endtime date

by using this table i have to fetch data from other three table by using

user_id employee_id service_id

employee table
employee_id pno name    age pic_path

user table
user_id pno name    age pic_path


service table
service_id  name    description


SELECT
    t.*,
    e.name AS employee_name,
    u.name AS user_name,
    s.name AS service_name, s.description
FROM tasks AS t
INNER JOIN employees AS e ON e.employee_id = t.employee_id
INNER JOIN users AS u ON u.user_id = t.user_id
INNER JOIN services AS s ON s.service_id = t.service_id
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜