Hi,
I want to write an SQL query which should return me 2 kinds of outputs depending on which condition is true. i.e.

the query should be something like

select someview if (condition1 = true)
else select someotherview if (condition2 = true)

where someview is a set of columns from one table only, and someotherview is a set of columns which is a superset of someview (& is generated from two tables, which have no common field)

Can I write a SQL query like this? Will an outer join help me?

Thanks & Regards,
Amit Parmar

An outerjoin is simply an inner join with the non-matching tuples included in the result set with null values representing the absent values.

How does the condition relate to the tables?