MySQL tham gia bảng
Một mệnh đề SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5 đượ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.
Hãy xem xét một lựa chọn từ bảng "Đơn đặt hàng":
10308 | 2 | 1996-09-18 |
10309 | 37 | 1996-09-19 |
10310 | 77 | 1996-09-20 |
Sau đó, nhìn vào một lựa chọn từ bảng "Khách hàng":
1 | 1996-09-20 | Sau đó, nhìn vào một lựa chọn từ bảng "Khách hàng": | Tên khách hàng |
2 | Tên Liên lạc | Quốc gia | Alfreds Futterkiste |
3 | Maria Anders | nước Đức | Alfreds Futterkiste |
Maria Anders
nước Đức
Ana Trujillo Emparedados Y Helados
Ana Trujillo
FROM Orders
INNER JOIN Customers ON
Orders.CustomerID=Customers.CustomerID;
Mexico
Antonio Moreno Taquería
10308 | Tên Liên lạc | Quốc gia |
10365 | Maria Anders | nước Đức |
10383 | Ana Trujillo Emparedados Y Helados | Ana Trujillo |
10355 | Ana Trujillo Emparedados Y Helados | Ana Trujillo |
10278 | Mexico | Antonio Moreno Taquería |
Antonio Moreno
- 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".
- Sau đó, chúng ta có thể tạo câu lệnh SQL sau (có chứa SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;6), chọn các bản ghi có giá trị phù hợp trong cả hai bảng:
- Thí dụ
- Chọn Order.OrderID, Khách hàng.CustomerName, Order.OrderDateFrom OrderInner Tham gia khách hàng theo đơn đặt hàng.CustomerId = customer.CustomerID;
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;
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
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 -
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.
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 : 98Truy 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ụ :
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.
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 : 79Truy 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ụ :
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.
Kết quả :
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;4Truy 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)
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 : hyderabad1
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 * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
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
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 : hyderabad2 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 : hyderabad3STUDENT-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 : hyderabad4STUDENT-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 : hyderabad5
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 : hyderabad6 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 : hyderabad3STUDENT-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 : hyderabad8STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid0 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid2STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid4 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid6STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8 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 : hyderabad3STUDENT-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 : 980 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 : 981STUDENT-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 : hyderabad222
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;3
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;07
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;08
Đầu ra:
Viết mã PHP để chèn chi tiết trong bảng student_marks. (data2.php) & nbsp;
PHP
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 : hyderabad1
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 : hyderabad2 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 : hyderabad3STUDENT-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 : hyderabad4STUDENT-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 : hyderabad5
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 : hyderabad6 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 : hyderabad3STUDENT-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 : hyderabad8STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid0 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid2STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid4 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid6STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8 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 : hyderabad3STUDENT-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 : 980 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 : 981STUDENT-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 : hyderabad222
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;3
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;56STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;60STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;64STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;68STUDENT-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 : hyderabad5
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid55SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid7
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 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 : 790STUDENT-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 : hyderabad5
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 : 792STUDENT-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 : 793 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 : 794
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 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 : 797 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;07
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;08
Đầ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;97
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;98
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 : hyderabad1
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 : hyderabad2 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 : hyderabad3STUDENT-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 : hyderabad4STUDENT-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 : hyderabad5
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 : hyderabad6 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 : hyderabad3STUDENT-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 : hyderabad8STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid0 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid2STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid4 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid6STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8 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 : hyderabad3STUDENT-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 : 980 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 : 981STUDENT-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 : hyderabad222
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;3
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;56STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;60STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;64STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;68STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;56STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;60STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;64STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;68STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;07
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;08
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid34
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid35
Đầu ra:
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid55SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid7
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 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 : 790STUDENT-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 : hyderabad5
PHP
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;97
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;98
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 : hyderabad1
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 : hyderabad2 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 : hyderabad3STUDENT-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 : hyderabad4STUDENT-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 : hyderabad5
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 : hyderabad6 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 : hyderabad3STUDENT-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 : hyderabad8STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid0 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid2STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid4 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid6STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8 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 : hyderabad3STUDENT-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 : 980 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 : 981STUDENT-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 : hyderabad222
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;3
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;56STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;60STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;64STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;68STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;55____51SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;7 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;8SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8__
________ 62 & nbsp; 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 : hyderabad3SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;5225
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;56STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;60STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;64STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid7SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;68STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;07
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;08
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid34
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid35
Đầu ra:
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;0 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid55SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid7
SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;4SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 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 : 790STUDENT-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 : hyderabad5
PHP
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;97
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;98
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 : hyderabad1
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 : hyderabad2 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 : hyderabad3STUDENT-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 : hyderabad4STUDENT-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 : hyderabad5
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 : hyderabad6 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 : hyderabad3STUDENT-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 : hyderabad8STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid0 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid2STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid4 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid6STUDENT-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 : hyderabad5
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8 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 : hyderabad3STUDENT-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 : 980 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 : 981STUDENT-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 : hyderabad222
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;07STUDENT-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 : hyderabad5
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 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 : hyderabad3SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;17STUDENT-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 : hyderabad5
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 : hyderabad41 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8STUDENT-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 : hyderabad444____62
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 : hyderabad47SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1STUDENT-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 : hyderabad49 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 : hyderabad50STUDENT-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 : hyderabad41STUDENT-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 : hyderabad52
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 : hyderabad53SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 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 : hyderabad3SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;17STUDENT-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 : hyderabad5
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid2 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 : hyderabad3SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;17STUDENT-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 : hyderabad5
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 : hyderabad41 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 : hyderabad3SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8STUDENT-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 : hyderabad444____62
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 : hyderabad47SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;1STUDENT-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 : hyderabad49 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 : hyderabad50STUDENT-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 : hyderabad41STUDENT-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 : hyderabad52
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 : hyderabad53SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;01STUDENT-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 : hyderabad5
SELECT * from student_address LEFT JOIN student_marks on student_address.sid=student_marks.sid1
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid8SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;07
SELECT * from student_address INNER JOIN student_marks on student_address.sid=student_marks.sid;08
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid34
SELECT * from student_marks INNER JOIN student_address on student_address.sid=student_marks.sid35
SELECT * from student_marks LEFT JOIN student_address on student_address.sid=student_marks.sid9 SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;60STUDENT-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 : hyderabad5
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 : hyderabad90 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 : hyderabad3SELECT column1,column2,...columnn FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;70STUDENT-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 : hyderabad5