Merge 2 Tables with SELECT FROM AS ON Query (M2TSFAOQ)

M2TSFAOQ:   SOLD       

---

Thanks to @Joseinnewworld who just bought my #collection brutally, 13 #NFTs #Wow 😱! you are a whale🐳. Also, your chosen #NFT gift has been sent🤝 #eCash $XEC #CRYPTO #nftcollectors #NFTTrading #NFTCommuntiy #NFTMarketplace #BitcoinWhales pic.twitter.com/RzbnBt9r4W

— Gaexe (@gaexe_) February 2, 2025

I happen to use the northwind database to learn about sql, I want to create a report or in other words I want to display data from two or more tables in the database. Well, how do you do that? Please enlighten me, bro, by giving an example or how so that I have an idea about it. Thank you, greetings newbie

I will try to give just 2 examples, hopefully you can digest them well.

METHOD 1

SELECT
*(jikat tidak menyebutkan kolom) ATAU p."nama_kolom" ATAU c."nama_kolom" ATAU p."nama_kolom", c."nama_kolom" ATAU sebaliknya
FROM
categories AS c, products AS p
WHERE
c.CategoryID=p.CatergoryID

Example 1.a:

SELECT *
FROM categories AS c, products AS p
WHERE c.CategoryID= p.CategoryID;

Output 1.a:

Example 1.b:

SELECT c.CategoryName, p.CategoryID
FROM categories AS c, products AS p
WHERE c.CategoryID= p.CategoryID;

Output 1.b:

METHOD 2

SELECT
*(jikat tidak menyebutkan kolom) ATAU p."nama_kolom" ATAU c."nama_kolom" ATAU p."nama_kolom", c."nama_kolom" ATAU sebaliknya
FROM
categories AS c JOIN products AS p
ON
c.CategoryID=p.CatergoryID

Example 2.a:

SELECT *
FROM
categories AS c JOIN products AS p
ON
c.CategoryID = p.CategoryID

Output 2.a:

Example 2.b:

SELECT c.CategoryName, p.UnitsInStock
FROM
categories AS c JOIN products AS p
ON
c.CategoryID = p.CategoryID

Output 2.b:

SOLD

• Facebook
• Twitter