{"id":67811,"date":"2024-07-02T00:00:35","date_gmt":"2024-07-01T20:30:35","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/sql-course-one-to-many-relationships-and-left-joins-pgm\/"},"modified":"2024-07-02T00:00:35","modified_gmt":"2024-07-01T20:30:35","slug":"sql-course-one-to-many-relationships-and-left-joins-pgm","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/sql-course-one-to-many-relationships-and-left-joins-pgm\/","title":{"rendered":"\u062f\u0648\u0631\u0647 SQL: \u0631\u0648\u0627\u0628\u0637 \u06cc\u06a9 \u0628\u0647 \u0686\u0646\u062f \u0648 \u067e\u06cc\u0648\u0633\u062a\u0646 \u0686\u067e"},"content":{"rendered":"

Summarize this content to 400 words in Persian Lang
\n \u062f\u0631 \u0641\u0635\u0644 \u0622\u062e\u0631 \u0628\u0627 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u06cc\u06a9 \u0628\u0647 \u06cc\u06a9 \u0648 \u067e\u06cc\u0648\u0646\u062f\u0647\u0627\u06cc \u062f\u0627\u062e\u0644\u06cc \u0622\u0634\u0646\u0627 \u0634\u062f\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 \u0641\u0635\u0644 \u0628\u0627 \u0631\u0648\u0627\u0628\u0637 \u06cc\u06a9 \u0628\u0647 \u0686\u0646\u062f \u0648 \u067e\u06cc\u0648\u0646\u062f\u0647\u0627\u06cc \u0686\u067e \u0622\u0634\u0646\u0627 \u0645\u06cc \u0634\u0648\u06cc\u0645. \u0627\u06af\u0631 \u0641\u0635\u0644 \u0622\u062e\u0631 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f\u060c \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0622\u0633\u0627\u0646 \u0628\u0627\u0634\u062f. <\/p>\n

\u06cc\u06a9 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f posts table \u0648 \u0627\u0644\u0641 post is related to one user \u0648 \u0627\u0644\u0641 user can have many posts. \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u0631\u0627\u0628\u0637\u0647 \u06cc\u06a9 \u0628\u0647 \u0686\u0646\u062f \u0645\u06cc \u06af\u0648\u06cc\u0646\u062f.<\/p>\n

\u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632 \u0628\u0627 \u0644\u06cc\u0646\u06a9<\/p>\n

\u062c\u062f\u0648\u0644 \u067e\u0633\u062a \u0647\u0627 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/p>\n

\u062c\u062f\u0648\u0644 \u067e\u0633\u062a \u0631\u0627 \u0628\u0627 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u062e\u0648\u062f\u0634 \u0648 \u06cc\u06a9 \u06a9\u0644\u06cc\u062f \u062e\u0627\u0631\u062c\u06cc \u0628\u0631\u0627\u06cc \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645. <\/p>\n

\u0628\u0627 \u0627\u062c\u0627\u0632\u0647 \u062f\u0627\u062f\u0646 \u0628\u0647 \u062c\u062f\u0648\u0644 \u067e\u0633\u062a\u200c\u0647\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0645\u0633\u062a\u0642\u0644\u060c \u0645\u062d\u062f\u0648\u062f\u06cc\u062a\u06cc \u0628\u0631\u0627\u06cc \u062f\u0627\u0634\u062a\u0646 \u06a9\u0644\u06cc\u062f \u062e\u0627\u0631\u062c\u06cc \u06cc\u06a9\u0633\u0627\u0646 \u0686\u0646\u062f\u06cc\u0646 \u067e\u0633\u062a \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f.<\/p>\n

CREATE TABLE Posts
\n(
\n ID INTEGER PRIMARY KEY AUTOINCREMENT,
\n UserID INTEGER NOT NULL,
\n Title VARCHAR(255) NOT NULL,
\n Content TEXT NOT NULL,
\n FOREIGN KEY (UserID) REFERENCES Users(ID)
\n);<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 \u067e\u0633\u062a \u0647\u0627 \u062f\u0631\u062c \u06a9\u0646\u06cc\u062f<\/p>\n

INSERT INTO Posts (UserID, Title, Content) VALUES
\n (1, ‘sql’, ‘sql content’),
\n (1, ‘java’, ‘java content’),
\n (2, ‘NLP’, ‘NLP content’),
\n (2, ‘rust’, ‘rust content’);<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u0628\u0627 \u0639\u0636\u0648\u06cc\u062a \u0686\u067e \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f.<\/p>\n

\u0645\u0627 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0647\u0645\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u06af\u0631 \u06a9\u0627\u0631\u0628\u0631 \u06cc\u06a9 \u067e\u0633\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u0622\u0646 \u067e\u0633\u062a \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n

SELECT u.Username, p.Title, p.Content
\nFROM Users u
\nLEFT JOIN Posts p ON u.ID = p.UserID;<\/p>\n

\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n

\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n

\u0646\u062a\u06cc\u062c\u0647: \u0628\u0646 | \u062c\u0627\u0648\u0627 | \u0645\u062d\u062a\u0648\u0627\u06cc \u062c\u0627\u0648\u0627\u0628\u0646 | sql | \u0645\u062d\u062a\u0648\u0627\u06cc sql\u062c\u06cc\u0645 | NLP | \u0645\u062d\u062a\u0648\u0627\u06cc NLP\u062c\u06cc\u0645 | \u0632\u0646\u06af \u0632\u062f\u06af\u06cc | \u0645\u062d\u062a\u0648\u0627\u06cc \u0632\u0646\u06af \u0632\u062f\u06af\u06cc\u0644\u0648\u06a9 | | <\/p>\n

\n

\u062f\u0631 \u0641\u0635\u0644 \u0622\u062e\u0631 \u0628\u0627 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u06cc\u06a9 \u0628\u0647 \u06cc\u06a9 \u0648 \u067e\u06cc\u0648\u0646\u062f\u0647\u0627\u06cc \u062f\u0627\u062e\u0644\u06cc \u0622\u0634\u0646\u0627 \u0634\u062f\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 \u0641\u0635\u0644 \u0628\u0627 \u0631\u0648\u0627\u0628\u0637 \u06cc\u06a9 \u0628\u0647 \u0686\u0646\u062f \u0648 \u067e\u06cc\u0648\u0646\u062f\u0647\u0627\u06cc \u0686\u067e \u0622\u0634\u0646\u0627 \u0645\u06cc \u0634\u0648\u06cc\u0645. \u0627\u06af\u0631 \u0641\u0635\u0644 \u0622\u062e\u0631 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f\u060c \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0622\u0633\u0627\u0646 \u0628\u0627\u0634\u062f. <\/p>\n

\u06cc\u06a9 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f posts table<\/code> \u0648 \u0627\u0644\u0641 post is related to one user<\/code> \u0648 \u0627\u0644\u0641 user can have many posts<\/code>. \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u0631\u0627\u0628\u0637\u0647 \u06cc\u06a9 \u0628\u0647 \u0686\u0646\u062f \u0645\u06cc \u06af\u0648\u06cc\u0646\u062f.<\/p>\n

\n
\n

\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n