Customers where would produce the following result

+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ |1|Ramesh|32|Ahmedabad|2000.00| |2|Khilan|25|Delhi|1500.00| |3| kaushik |23|Kota|2000.00| |4|Chaitali|25|Mumbai|6500.00| |5|Hardik|27|Bhopal|8500.00| |6|Komal|22| MP |4500.00| |7|Muffy|24|Indore|10000.00| +----+----------+-----+-----------+----------+

+------+----------+--------+---------------------+ | ID | NAME | AMOUNT | DATE | +------+----------+--------+---------------------+ |1|Ramesh| NULL | NULL | |2|Khilan|1560|2009-11-2000:00:00| |3| kaushik |3000|2009-10-0800:00:00| |3| kaushik |1500|2009-10-0800:00:00| |4|Chaitali|2060|2008-05-2000:00:00| |5|Hardik| NULL | NULL | |6|Komal| NULL | NULL | |7|Muffy| NULL | NULL | |3| kaushik |3000|2009-10-0800:00:00| |3| kaushik |1500|2009-10-0800:00:00| |2|Khilan|1560|2009-11-2000:00:00| |4|Chaitali|2060|2008-05-2000:00:00|

ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID
UNION ALL
SELECT ID, NAME, AMOUNT, DATE
FROM CUSTOMERS
RIGHT JOIN ORDERS
ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID

+----+----------+-----+-----------+----------+ | ID | NAME | AGE | ADDRESS | SALARY | +----+----------+-----+-----------+----------+ |1|Ramesh|32|Ahmedabad|2000.00| |2|Khilan|25|Delhi|1500.00| |3| kaushik |23|Kota|2000.00| |4|Chaitali|25|Mumbai|6500.00| |5|Hardik|27|Bhopal|8500.00| |6|Komal|22| MP |4500.00| |7|Muffy|24|Indore|10000.00| +----+----------+-----+-----------+----------+