当前位置：网站首页>175. Combine two tables (MySQL database connection)

175. Combine two tables (MySQL database connection)

2022-07-19 07:52:00 【Listen 1024】

List of articles

Question

175. Combine two tables

Insert picture description here 

 source ： Power button （LeetCode）
 link ：https://leetcode.cn/problems/merge-in-between-linked-lists/
 Copyright belongs to the network . For commercial reprint, please contact the official authority , Non-commercial reprint please indicate the source .

Ideas

1、Answer( MySQL) - Simple database connection

Solution ideas ： Simple database connection

Code

# Write your MySQL query statement below
SELECT 
    P.FirstName,
    P.LastName,
    A.City,
    A.State
FROM Person P
LEFT JOIN Address A
    ON P.PersonId = A.PersonId
原网站

版权声明
本文为[Listen 1024]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/200/202207170539295918.html

边栏推荐

猜你喜欢

随机推荐