A constant meets a table

Question

Accepted Answer

Selecting a literal repeats that value for every row in the source table - one output row per source row. With 3 employees the result has 3 rows, all with the value 'active' in the status column. This pattern is useful for tagging all rows from a table before combining them with UNION.

id	name
1	Alice
2	Bob
3	Carol