How can I chain together SELECT EXISTS() queries? <p>I have this simple query</p> <pre><code>SELECT EXISTS(SELECT a FROM A WHERE a = 'lorem ipsum'); </code></pre> <p>That will return a 0 or 1 if there exists a row in A that contains 'lorem ipsum'</p> <p>I would like to chain this behavior together. So I would get multiple rows, each with a 0 or 1 if that value exists.</p> <p>How would I go about doing this?</p> <p>Update:</p> <p>It's possible to do it like this but then I get a column for each result.</p> <pre><code>SELECT EXISTS(SELECT a FROM A WHERE a = 'lorem ipsum'), EXISTS(SELECT a FROM A WHERE a = 'dolor sit'); </code></pre>