 |
ขอสอบถาม join 2 table ให้แสดงตามที่กำหนด ต้องเขียนอย่างไรครับ |
| |
 |
|
|
 |
 |
|
Code (PHP)
$query="SELECT post_book.*,send_book.* FROM post_book INNER JOIN send_book ON post_book.id = send_book.id_book WHERE send_book.status ='0' GROUP BY post_book.location";
แต่ข้อมูลที่แสดงยังไม่ครบตามต้องการ
1. กรุงเทพ ส่ง 63_001
2. ตรัง ส่ง 63_001
3. ชุมพร ส่ง 63_002
4. ยะลา ส่ง 63_002
|
ประวัติการแก้ไข
2020-03-31 14:58:20
 |
 |
 |
 |
| Date :
2020-03-31 14:56:57 |
By :
youboom |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (SQL)
select id, name, group_concat(id_book) from (
select p.*, s.id_book from province as p, send_book as s where p.id = s.p_1
union all
select p.*, s.id_book from province as p, send_book as s where p.id = s.p_2
union all
select p.*, s.id_book from province as p, send_book as s where p.id = s.p_3
union all
select p.*, s.id_book from province as p, send_book as s where p.id = s.p_4
} as s group by name
|
| |
|
|
| |
| Date :
2020-03-31 15:07:48 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
GROUP_CONCAT() น่าจะช่วยได้ครับ
https://www.thaicreate.com/tutorial/sql-group-concat.html
Code (SQL)
$query="SELECT post_book.location, GROUP_CONCAT(send_book.id_book) AS id_book
FROM post_book
INNER JOIN send_book ON post_book.id = send_book.id_book
WHERE send_book.status ='0'
GROUP BY post_book.location";
|
| |
|
|
| |
| Date :
2020-03-31 20:07:50 |
By :
{Cyberman} |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
