how to show data from two different table in database

Dear sir how to show data from two different table it has not relation between

 

Query one, then query the other?

If they have the same structure then A--Your database isn't normalized, and B--you can use a UNION query.

http://www.techonthenet.com/sql/union.php

 

Quite an odd question... Hehehe, what is the usage? Just to see the content of the tables? Or are you going to use the data and display it somewhere else? plog's suggestion is so right ^^

By the way, if you want to see part of the data on both tables to compare it, you can select part of them in 2 queries, such as

select top 5* from table1
select top 5* from table2

Code (markup):

Then, execute both