Re: views...

here is my problem...

I am creating a view with table A with 10 columns col1 - col10.

I have a reference table b that has a foreign key to a . this table (b) is what contains the value b.col2 that I need to use below

I need to add a column new_col to the view that has a 1 or 0 based on the following.

new_col is 1 if b.col2 in (select * from c (one column table) and 0 otherwise.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 31 1999 - 09:36:22 CST