No I've never encountered that, but I like the idea of an interviewer asking those types of questions--it seems like a great way to weed out the true morons.

But personally,...

Thanks. Yeah, this one runs concurrently with a Visual Studio and ASP.Net conference. Also, thanks for the heads up on PASS.

Neato. Thank you very much for the response.

Try this:

SELECT ID, Name, (SELECT total from OtherTable WHERE OtherTable.FirstTableID=FirstTable.ID) AS OTotal FROM FirstTable;

That should work as long as the sub-query only returns one record. You'll need to do...