需要在两个表上显示数据的帮助 [英] need help on two tables to show data

问题描述

嗨 我需要帮助才能从两个表中获取数据，一个是 hs_hr_leave ，另一个是 hs_hr_leavetype
表 hs_hr_leave
中有字段 Leave_id
休假日期
Leave_length_hours
Leave_length_days
Leave_status
Leave_comments
Leave_request_id
Leave_type_id
employee_id
start_time
end_time
和表 hs_hr_leavetype 具有
Leave_type_id
Leave_type_name
available_flag

我想显示离开日期，离开状态和第二个表中的离开类型名称
和Leave_type_id在两个表中都是常见的
我当时使用的是Join，但无法做到这一点，我需要专家plz的帮助

我正在使用此
$ sql ="SELECT hs_hr_leave.*，hs_hr_leavetype.leave_type_name FROM`hs_hr_leave`，`hs_hr_leavetype` JOIN`hs_hr_leavetype` ON hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_ <2方案

sql ="SELECT hs_hr_leave.*，hs_hr_leavetype.leave_type_name FROM`hs_hr_leave`，`hs_hr_leavetype` JOIN`hs_hr_leavetype` ON hs_hr_leave.leave_type_id = hs_hr_leave> br/>

尝试:

  SELECT 
    hs_hr_leave.leave_date，
    hs_hr_leave.leave_status，
    hs_hr_leavetype.leave_type_name
 FROM 
    hs_hr_leave
 INNER   JOIN 
    hs_hr_leavetype
打开 hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_id 

我认为这是可行的，但未使用代码显示数据

同时(

hi i need help to get data from two table one is hs_hr_leave and other is hs_hr_leavetype
there are the fields which are in table hs_hr_leave
leave_id
leave_date
leave_length_hours
leave_length_days
leave_status
leave_comments
leave_request_id
leave_type_id
employee_id
start_time
end_time
and table hs_hr_leavetype have
leave_type_id
leave_type_name
available_flag

i want to show leave_date , leave_status and from second table leave_type_name
and leave_type_id is common in both tables
i was using join but cant do it i need help from experts plz

i am using this
$sql ="SELECT hs_hr_leave.*, hs_hr_leavetype.leave_type_name FROM `hs_hr_leave`,`hs_hr_leavetype` JOIN `hs_hr_leavetype` ON hs_hr_leave.leave_type_id=hs_hr_leavetype.leave_type_id ";

解决方案

sql ="SELECT hs_hr_leave.*, hs_hr_leavetype.leave_type_name FROM `hs_hr_leave`,`hs_hr_leavetype` JOIN `hs_hr_leavetype` ON hs_hr_leave.leave_type_id=hs_hr_leavetype.leave_type_id ";

Try:

SELECT 
    hs_hr_leave.leave_date,
    hs_hr_leave.leave_status,
    hs_hr_leavetype.leave_type_name 
FROM 
    hs_hr_leave
INNER JOIN 
    hs_hr_leavetype 
ON hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_id

i think it works but not showing data using the code

while (

这篇关于需要在两个表上显示数据的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！