SQL Query for searching table 'C' records only if records from table 'A' has specific values
Vivek - just use (Left or Right) outer joins. This will make sure that the null values will be shown if the data does not exist within the joined table.