Providing MySQL a manually-typed list of rows to left join with?
===

My Google-Fu is weak on this one, so mayhaps you all can help.

If you want to select multiple columns, you can do...

`SELECT 'something' as userName, 'fooBar' as typicalSaying`

And you'd get:

    +----------------+-----------------+
    |    userName    |   typicalSaying |
    +----------------+-----------------+
    |   something    |    fooBar       |
    +----------------+-----------------+

However, how do I do the above with rows?

EG:

    SELECT someLine, effy.text from table
    LEFT JOIN (SELECT 'a' as text UNION 'b' UNION 'c') as effy 

**EDIT:**
To get a result like..

    +----------------+--------------+
    |    someLine    |   effy.text  |
    +----------------+--------------+
    |   entryA       |    a         |
    |   entryA       |    b         |
    |   entryA       |    c         |
    +----------------+--------------+

