Using MSSQL Management Studio on daily basis, makes me look like such a fool when using MySQL: How can I combine irrelevant queries in one without any join intended? I am basically just looking for a 开发者_如何转开发simple view of a couple of tables:
SELECT * FROM FOO LIMIT 1
SELECT * FROM BOO LIMIT 1
Definitely join and union does not work since they supposedly do not have any shared columns.
Thank!
Does it have to be in the one result table?
SELECT * FROM FOO LIMIT 1;
SELECT * FROM BOO LIMIT 1;
精彩评论