YOUR AD GOES HERE

day 45 | 50 Days of SQL | SELECT AS FROM UNION | SQL Query

Published 10, Dec 2023

SAHAS H S

0 75 Download

Description:
Merging Customer and Supplier Data with Table Origin Column

You have access to two tables: customers and suppliers. Your objective is to:

Select the columns city, company_name, and contact_name from both tables.
Merge the results together.
Add an additional column in the result set to specify the origin of each record. This column should contain either 'customers' or 'suppliers' to indicate from which table the record came. Make sure name of this column is relationship
Concepts to Consider
Think about how you can merge results from two separate queries.
Consider how to add static values to a result set for classification purposes.
Ensure your final query is structured and formatted correctly. Once you believe you have the correct solution, submit your query for validation. Best of luck!

Query:
select city,company_name,contact_name,'customers' as relationship from customers union select city,company_name,contact_name,'suppliers' as relationship from suppliers
#codedamn #challenge #solution #sql #50dayschallenge #query #simple

Releted More Videos

You May Also Like

YOUR AD GOES HERE

Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 04:46
What is a database schema?
ness-intricity101
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 04:41
SQL SELECT STATEMENT - COMPLEX
William McConnell
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
#mixtape
tube xpt
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 01:18
98UU76NBT5RRE
tigtb1slC
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
Basic SELECT Statement in MySQL Workbench #sql #excel #dataanalytics
Quazi Analytics
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 18:08
Master the SQL SELECT statement part 07: WITH and Common Table Expressions (CTE's)
Michael Fudge
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
03 - How to code PHP if statements
How to code well
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
SQL : Select only if one user role in SQL
Hey Delphi
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 06:50
ETL vs ELT — Understanding Extract, Transform, Load vs Extract, Load, Transform | Uplatz
Uplatz
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
How to upload videos in YouTube full hd quality | High Quality me Video Upload kaise kare 2025
Chaurasia Tips for Tech
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
The BEST WAY to Remove a YouTube Copyright Claim
vidIQ
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 02:47
Don’t Confuse The System With The Product! #infinitebanking
InsuranceandEstates.com
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 01:24
Write Cleaner SQL with CTEs! ????????
Lore So What
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
#sqlqueries Find distinct count of rows using SQL query
Tableau Tutor
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 01:30
SQL : select the n-1 rows of a query
Hey Delphi
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 28:22
SQL SELECT PART 01
Programming Made Easy
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 01:24
Windows Phone 7 longlistselector
Roel Van de Paar
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script
Print the given pattern in Python ( python for beginners )
AshMit Academy
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 01:19
SQL : Select distinct values with count in PostgreSQL
Hey Delphi
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 31:28
Learn Python in 30 minutes
Frank A
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 01:29
SQL 05 - SELECT DISTINCT columns FROM
夏sir網上教室
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 03:37
Error code: vhf43CVg7 online scam removal video.
Andrey Gvozd
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 27:33
Дэмакратыя: плюсы і мінусы | RadioRadix #18
Radix | Мікола Дзядок | Николай Дедок
Day 45 50 Days Of SQL SELECT AS FROM UNION SQL Query - YouTube Auto PHP Script 00:00
Python Full Course For Beginners (Learn How To Code in 2025)
Erik Frits
Share Modal

Share this link via

Or copy link

YOUR AD GOES HERE