Is it possible to write multiple commands in a single statement, if so how? I've tried separating each statement using a semicolon but that doesn't seem to work - only the first one is processed, eg select a from table; select b from table returns only the results of select a from table.