Hello All, I need to include a derived field in a view based on whether a certain value is present in another table ( does that make sense ? ). The problem is, the table in question can have more than one record but I'm only interested in a certain type, any ideas as to how I can do this ?

pseudo code

Select * from table1 and if there is a record of type 'X' in table2 set field2 to 1 else set field2 to 0