Is it possible to write Showcase query using subquery ?SELECT column-names FROM table1 WHERE value IN (SELECT column-name FROM table2 WHERE condition)