how to display more than two tables content without using join.?

Answer 1

instead of join we can use ,
for example if we want salary from employees and city from customers where name is same
select employees.salary,customers.city from employees,customers where employees.name=customers.name;

Answer 2

By using the union all we can join the two table tables

Answer 3

by equating the same field like customers.id=seller.id from both the tables customers and seller

Answer 4

Ya you can either use union or enter a subquery as per ur requirements

Answer 5

Union or union all

Answer 6

Correct @lipi

Answer 7

u can use union or union all if the two table has the same number of columns