Select something from myTable
If something is equal to 'Cat' then do SQL A , otherwise do SQL B.
Is this where Selects inside of selects come into play? Is there another way to do this?
It's possible, each SQL flavor has their version. A good place to look is google "stored procedure (flavor of SQL) IF Then statement"
Generally this is frowned upon as databases should avoid containing logic. But there was this time during the 90's when engineers went crazy with stored procedures and moved logic to the database in before map-reduce and distributed logic became easier to implement.
The SQL is for testing. I want to put it in a test case to say run a query and compare the output against some other data. I was hoping to avoid having to put in a lot of sentences saying Run SQL A. If the name is "kevin" then do query B for the next step. Otherwise do query C for the next step. I wont have a storage area for stored procedures.
Any other ideas?
When in Florida, Don't Tampa with the code. I made this up.