>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

SELECT *, 
   (CASE WHEN EXISTS (SELECT * FROM OtherTable where ...) THEN 1 ELSE 0 END) as whatever
   FROM table1