PHP script for search and display datas from database tables connected with foreign key
These are two tables with foreign key enquiry_id. Please help me to do a search and display the data of these tables combined like enquiry_id, enroll开发者_JAVA百科ment_id, installment_date, installment_receipt, installment_amount and student_name, student_contact, student_address, Student_course from student_installment_table and student_enquiry_table.
SELECT enrollment_id, installment_date, installment_receipt, installment_amount, student_name, student_contact, student_address, student_course FROM student_installment_table INNER JOIN student_enquiry_table ON student_installment_table.enquiry_id = student_enquiry_table.enquiry_id
精彩评论