search

Hướng dẫn what is join query in php? - tham gia truy vấn trong php là gì?

Ngày đăng: 19/10/2022
Trả lời: 0
Lượt xem: 32

Trong bài viết này, chúng tôi sẽ tham gia hai bảng bằng PHP và hiển thị chúng trên trang web. & NBSP;

Show

Giới thiệu :

PHP là ngôn ngữ kịch bản phía máy chủ, được sử dụng để kết nối với cơ sở dữ liệu. Sử dụng điều này, chúng ta có thể lấy dữ liệu từ cơ sở dữ liệu bằng cách sử dụng các tập lệnh PHP. Ngôn ngữ cơ sở dữ liệu có thể được sử dụng để giao tiếp với PHP là MySQL. MySQL là ngôn ngữ truy vấn cơ sở dữ liệu được sử dụng để quản lý cơ sở dữ liệu.

Yêu cầu:

Máy chủ XAMPP - Máy chủ XAMPP được sử dụng để lưu trữ cơ sở dữ liệu của chúng tôi tại địa phương. & nbsp; chúng tôi sẽ truy cập dữ liệu từ máy chủ XAMPP bằng PHP.

Trong bài viết này, chúng tôi đang lấy cơ sở dữ liệu chi tiết sinh viên có chứa hai bảng. Họ là Student_Address và Student_marks.

Cấu trúc của bảng:

table1=student_address

Hướng dẫn what is join query in php? - tham gia truy vấn trong php là gì?

table2=student_marks.

Chúng tôi sẽ thực hiện tham gia bên trong, tham gia bên trái, tham gia bên phải trên hai bảng này.

1. Tham gia bên trong:

Tham gia bên trong là một từ khóa chọn các bản ghi có các giá trị phù hợp trong cả hai bảng.

Cú pháp:

SELECT column 1,column 2,...column n
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

Thí dụ :

Hãy để student_address chứa những chi tiết này

Và bảng student_marks bao gồm

Bằng cách sử dụng SID, chúng ta có thể tham gia hai bảng này bằng cách sử dụng tham gia bên trong, vì, SID là phổ biến trong hai bảng.

  • Truy vấn hiển thị chi tiết Student_address dựa trên tham gia bên trong -
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;

Kết quả :

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
  • Truy vấn để hiển thị chi tiết Student_marks dựa trên tham gia bên trong.
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid

Kết quả :

STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98

Truy vấn để hiển thị chi tiết Student_marks dựa trên tham gia bên trong.

2. Tham gia trái:

Cú pháp:

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
  • Thí dụ :
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid

Kết quả :

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
STUDENT-ID : ----- NAME : gnanesh ----- ADDRESS : hyderabad
  • Truy vấn để hiển thị chi tiết Student_marks dựa trên tham gia bên trong.
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid

Kết quả :

STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79

Truy vấn để hiển thị chi tiết Student_marks dựa trên tham gia bên trong.

2. Tham gia trái:

Cú pháp:

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
0
  • Thí dụ :
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
1

Kết quả :

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
2
  • Truy vấn để hiển thị chi tiết Student_marks dựa trên tham gia bên trong.
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
3

Kết quả :

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
4

Truy vấn để hiển thị chi tiết Student_marks dựa trên tham gia bên trong.

  • 2. Tham gia trái:
  • Từ khóa tham gia bên trái được sử dụng để trả về tất cả các bản ghi từ bảng bên trái (Bảng 1) và các bản ghi phù hợp từ bảng bên phải (Bảng 2).
  • Truy vấn để hiển thị tất cả bảng student_address dựa trên ID sinh viên bằng cách sử dụng & nbsp; tham gia trái
  • Truy vấn để hiển thị tất cả các sinh viên_mark & ​​nbsp; bảng dựa trên id sinh viên

Steps:

  • 3. Tham gia bên phải:

  • Từ khóa tham gia bên phải được sử dụng để trả về tất cả các bản ghi từ bảng bên phải (Bảng 2) và các bản ghi phù hợp từ bảng bên trái (Bảng 1). & NBSP;

Truy vấn để hiển thị tất cả bảng student_address dựa trên ID sinh viên bằng cách sử dụng & nbsp; tham gia đúng

Truy vấn để hiển thị tất cả các sinh viên_mark & ​​nbsp; bảng dựa trên id sinh viên

  • Cách tiếp cận :

Tạo cơ sở dữ liệu có tên cơ sở dữ liệu và tạo bảng (student_address và student_marks)

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
5

Chèn bản ghi vào hai bảng bằng PHP

Viết SQL & NBSP; truy vấn để thực hiện tất cả các lần tham gia bằng PHP

Quan sát kết quả.

Bắt đầu máy chủ XAMPP

Nhập trực tuyến localhost/phpmyadmin, trong trình duyệt của bạn và tạo cơ sở dữ liệu có tên là cơ sở dữ liệu, sau đó tạo hai bảng có tên student_address và student_marks

Student_address & nbsp; cấu trúc bảng:

Cấu trúc bảng student_marks:

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

Chèn các bản ghi vào bảng Student_Address bằng cách sử dụng mã chạy PHP (Data1.php) bằng cách nhập bản địa localhost/data1.php,

PHP

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
8
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
0 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
222

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
6
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
0 ____19

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
4 
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7____________
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
4 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
7

STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
9
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
1 
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
2
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
4

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
01

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
02

________ 56 & nbsp; 

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
8
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid
1
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid
2
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

Tạo cơ sở dữ liệu có tên cơ sở dữ liệu và tạo bảng (student_address và student_marks)

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
5

Chèn bản ghi vào hai bảng bằng PHP

Viết SQL & NBSP; truy vấn để thực hiện tất cả các lần tham gia bằng PHP

Quan sát kết quả.

Bắt đầu máy chủ XAMPP

Nhập trực tuyến localhost/phpmyadmin, trong trình duyệt của bạn và tạo cơ sở dữ liệu có tên là cơ sở dữ liệu, sau đó tạo hai bảng có tên student_address và student_marks

Student_address & nbsp; cấu trúc bảng:

Cấu trúc bảng student_marks:

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

Chèn các bản ghi vào bảng Student_Address bằng cách sử dụng mã chạy PHP (Data1.php) bằng cách nhập bản địa localhost/data1.php,

PHP

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
8
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
0 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
222

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
6
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
0 ____19

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
4 
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7____________
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
4 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
7

STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
9
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
1 
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
2
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
4

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
01

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
02

Đầu ra:

Gõ là localhost/data2.php, để xem đầu ra

Viết mã PHP để thực hiện tham gia bên trong (form.php)

PHP

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
91

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
92

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
5

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
8
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
0 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
222

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
6
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
0 ____19

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
4 
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7____________
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
23
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
38
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
41
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
43 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
44
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
46

Các

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
47
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
38
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
41
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
43 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
44
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
46

Các

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
47
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
01

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
02

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
28

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
29

Đầu ra:

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
76
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
84 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
86
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

PHP

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
91

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
92

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
5

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
8
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
0 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
222

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
6
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
0 ____19

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
4 
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7____________
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
23
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
38
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
41
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
43 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
44
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
46

Các

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
47
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
38
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
41
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
43 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
44
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
46

Các

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
47
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
01

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
02

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
28

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
29

Đầu ra:

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
76
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
84 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
86
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

PHP

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
91

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
92

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
5

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
8
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
0 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
222

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
6
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
0 ____19

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
4 
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
6
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7____________
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
4
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
8
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
23
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
38
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
41
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
43 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
44
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
46

Các

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
47
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
33
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35 
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
7
SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
38
SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
6
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
3

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
41
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
5
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
43 
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
44
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
35
STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
46

Các

STUDENT-ID : 1 ----- NAME : sravan kumar ----- ADDRESS : kakumanu
STUDENT-ID : 2 ----- NAME : bobby ----- ADDRESS : kakumanu
STUDENT-ID : 3 ----- NAME : ojaswi ----- ADDRESS : hyderabad
STUDENT-ID : 4 ----- NAME : rohith ----- ADDRESS : hyderabad
47
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid
3 
STUDENT-ID : 1 ----- SUBJECT 1 : 98 ----- SUBJECT 2 : 99
STUDENT-ID : 2 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 89
STUDENT-ID : 3 ----- SUBJECT 1 : 78 ----- SUBJECT 2 : 98
STUDENT-ID : 4 ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 98
STUDENT-ID : ----- SUBJECT 1 : 89 ----- SUBJECT 2 : 79
5
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
9

SELECT column1,column2,...columnn
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
5

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
2
SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
01

SELECT  * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;
02

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
28

SELECT  * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid
29

Đầu ra:

Loại & nbsp; localhost/form2.php trong trình duyệt


Truy vấn tham gia là gì?

Tham gia là một mệnh đề SQL được sử dụng để truy vấn và truy cập dữ liệu từ nhiều bảng, dựa trên các mối quan hệ logic giữa các bảng đó. Nói cách khác, tham gia chỉ ra cách SQL Server nên sử dụng dữ liệu từ một bảng để chọn các hàng từ bảng khác.an SQL clause used to query and access data from multiple tables, based on logical relationships between those tables. In other words, JOINS indicate how SQL Server should use data from one table to select the rows from another table.

Tại sao chúng tôi sử dụng Truy vấn tham gia?

Một mệnh đề tham gia được sử dụng để kết hợp các hàng từ hai hoặc nhiều bảng, dựa trên một cột liên quan giữa chúng.Lưu ý rằng cột "customerID" trong bảng "Đơn hàng" đề cập đến "Ứng dụng khách hàng" trong bảng "Khách hàng".Mối quan hệ giữa hai bảng trên là cột "customerID".to combine rows from two or more tables, based on a related column between them. Notice that the "CustomerID" column in the "Orders" table refers to the "CustomerID" in the "Customers" table. The relationship between the two tables above is the "CustomerID" column.

Tham gia với ví dụ là gì?

Tham gia có nghĩa là gì?Tham gia là một thao tác SQL được thực hiện để thiết lập kết nối giữa hai hoặc nhiều bảng cơ sở dữ liệu dựa trên các cột phù hợp, do đó tạo ra mối quan hệ giữa các bảng.Hầu hết các truy vấn phức tạp trong hệ thống quản lý cơ sở dữ liệu SQL đều liên quan đến các lệnh tham gia.Có nhiều loại tham gia khác nhau.an SQL operation performed to establish a connection between two or more database tables based on matching columns, thereby creating a relationship between the tables. Most complex queries in an SQL database management system involve join commands. There are different types of joins.

Tham gia và loại là gì?

Câu lệnh tham gia SQL được sử dụng để kết hợp dữ liệu hoặc hàng từ hai hoặc nhiều bảng dựa trên một trường chung giữa chúng.Các loại tham gia khác nhau như sau: Tham gia bên trong.CHỖ NỐI BÊN TRÁI.Đúng vậy tham gia.

programming php SQL JOIN MySQL JOIN LEFT JOIN SQL

Bài Viết Liên Quan

Cách làm vở bài tập ngữ văn lớp 7 năm 2024
Cách làm vở bài tập ngữ văn lớp 7 năm 2024

mẹo hay Mẹo Hay Cách Khỏe Đẹp Bài tập
Các bài toán dành cho hs lớp 1 năm 2024
Các bài toán dành cho hs lớp 1 năm 2024

mẹo hay
Thế nào là một người phụ nữ quyến rũ năm 2024
Thế nào là một người phụ nữ quyến rũ năm 2024

mẹo hay Hỏi Đáp Thế nào Giới Tính Phụ nữ
Hình thức hợp đồng trọn gói là gì năm 2024
Hình thức hợp đồng trọn gói là gì năm 2024

là ai Hỏi Đáp Là gì
Phòng khám 125 thái thịnh bác sĩ nào tốt năm 2024
Phòng khám 125 thái thịnh bác sĩ nào tốt năm 2024

mẹo hay Hơn
Ngày 8 12 là cung gì năm 2024
Ngày 8 12 là cung gì năm 2024

là ai
Phản ứng hóa học trong chế tạo vật liệu ceramic năm 2024
Phản ứng hóa học trong chế tạo vật liệu ceramic năm 2024

mẹo hay Học Tốt Học
Quan thổ công đông trù tư mệnh là gì năm 2024
Quan thổ công đông trù tư mệnh là gì năm 2024

là ai Hỏi Đáp Là gì
Bài tập tiếng anh thì htđ và thì httd năm 2024
Bài tập tiếng anh thì htđ và thì httd năm 2024

mẹo hay Khỏe Đẹp Bài tập Học Tốt Tiếng anh
Dân số kế hoạch hóa gia đình là gì năm 2024
Dân số kế hoạch hóa gia đình là gì năm 2024

mẹo hay Hỏi Đáp Là gì
Bộ khuếch đại thuật toán để lặp lại thế năm 2024
Bộ khuếch đại thuật toán để lặp lại thế năm 2024

mẹo hay
Heệ số công suât nhiệt điện trở là gì năm 2024
Heệ số công suât nhiệt điện trở là gì năm 2024

là ai Hỏi Đáp Là gì
Lỗi fail to find build tools revision 23.0.1 năm 2024
Lỗi fail to find build tools revision 23.0.1 năm 2024

mẹo hay
Take something for granted là gì năm 2024
Take something for granted là gì năm 2024

là ai Hỏi Đáp Là gì Cryto Eth Granted là gì Taken for granted
Bài tập về so sánh hơn có đáp án năm 2024
Bài tập về so sánh hơn có đáp án năm 2024

mẹo hay Khỏe Đẹp Bài tập So Sánh So sánh
Iphone lock báo lỗi kích hoạt liên hệ apple năm 2024
Iphone lock báo lỗi kích hoạt liên hệ apple năm 2024

mẹo hay Công Nghệ Iphone Apple
The ball is in your court nghĩa là gì năm 2024
The ball is in your court nghĩa là gì năm 2024

là ai Hỏi Đáp Là gì Ngôn ngữ Nghĩa là gì
Http www.animesex.pro en search highschool 20dxd-top 1.html năm 2024
Http www.animesex.pro en search highschool 20dxd-top 1.html năm 2024

mẹo hay Top List Top
Lỗi word không in được excell lại in được năm 2024
Lỗi word không in được excell lại in được năm 2024

mẹo hay
Đơn vị quản lý khu đất tiếng anh là gì năm 2024
Đơn vị quản lý khu đất tiếng anh là gì năm 2024

là ai Hỏi Đáp Là gì Học Tốt Tiếng anh

Quảng Cáo

Có thể bạn quan tâm

Thông tư 133 dùng cho doanh nghiệp nào năm 2024
1 ngày trước . bởi FurtiveCanonization
Counter improvised explosive device c-ied là gì năm 2024
1 ngày trước . bởi PermissiveAttractiveness
Magnific popup cannot read property top of undefined năm 2024
1 ngày trước . bởi ViableSperm
Hệ bài tiết có cấu tạo như thế nào năm 2024
1 ngày trước . bởi Well-dressedStanza
Bài văn tả về nàng tiên ốc lớp 4 năm 2024
1 ngày trước . bởi BlasphemousLocality
Lột da tay và chân là thiếu chất gì năm 2024
1 ngày trước . bởi IncipientManga
Bài viết về văn hóa manga anime nhật năm 2024
1 ngày trước . bởi TediousPrototype
Thứ hai tiếng anh gọi là gì năm 2024
1 ngày trước . bởi IntriguingDeduction
Lap top thiet ke do hoa 20 trieu năm 2024
1 ngày trước . bởi DiffuseReader
Red theatre thứ tội lỗi đẫm màu sắc dâm dục năm 2024
1 ngày trước . bởi PurportedAllocation

Toplist được quan tâm

#1
Top 4 uống nước chanh sả mật ong có tác dụng gì 2023
6 tháng trước
#2
Top 10 bài tập làm văn số 5 lớp 7 de 4 2023
6 tháng trước
#3
Top 3 vừa chơi đã có tài khoản vương giả chap 1 2023
6 tháng trước
#4
Top 6 anh sẽ on thôi cover phạm nguyên ngọc lyrics 2023
6 tháng trước
#5
Top 7 tài liệu quản lý nhà nước và quản lý ngành giáo dục đào tạo 2023
6 tháng trước
#6
Top 7 hãy ra khỏi người đó đi hợp âm 2023
6 tháng trước
#7
Top 6 giáo án thơ về thăm nhà bác 2023
6 tháng trước
#8
Top 8 giáo án ngữ văn 6 cánh diều 2023
6 tháng trước
#9
Top 9 tinh bột tham gia phản ứng nào 2023
6 tháng trước

Quảng cáo

Xem Nhiều

Các sở ban ngành tiếng trung là gì năm 2024
5 ngày trước . bởi LoathsomeOuting
Chèn ảnh có sẵn trong word vào văn bản năm 2024
1 ngày trước . bởi OriginalCorrelation
Đề thi môn toán lớp 8 học kì 2 năm 2024
6 ngày trước . bởi AgonizedHostility
Top 10 leadership qualities that make good leaders năm 2024
5 ngày trước . bởi ParalyzedInstructor
Bài 37 sgk toán 9 tập 1 trang 94 năm 2024
3 ngày trước . bởi UrbanPeter
Đầu số 0766 là mạng gì năm 2024
1 tuần trước . bởi SemanticTrauma
Bluestack là gì chơi có quảng cáo không năm 2024
4 ngày trước . bởi DevotedOutdoors
Công văn thu hồi hóa đơn xuất dư năm 2024
1 tuần trước . bởi NarrowRunoff
Mổ mắt cận thị ở bệnh viện nào tốt nhất năm 2024
6 ngày trước . bởi NamelessProspectus
Bị hạt gạo ở móng tay là bị gì năm 2024
11 giờ trước . bởi Two-year-oldLitigation

Quảng cáo

Chúng tôi

Điều khoản

Trợ giúp

Mạng xã hội

DMCA.com Protection Status
Bản quyền © 2021 Hàng Hiệu Inc.