On Jun 9, 8:12 am, Rodrigo De León <[EMAIL PROTECTED]> wrote: > On Jun 8, 7:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > wrote: > > > > > i have 4 tables : > > > date_table (date_id,.....) > > A_table(A_table_id, something1,something2.........) > > A1_table(A1_table_id references A_Table(A_Table_id),A11,A12........) > > A2_table(A2_table_id references A_Table(A_table_id),A21,A22,.......) > > > so i want to create a view with date_id,A_table_id,something1, > > if something2=x then my view containts > > (A1_table.A11 and A1_table.A12) > > else it's containts (A2_table.A21 and A2_table.A22)) > > > so my view depends of something2 value. > > > I hope i'm specific > > > Thx > > Lhaj > > create view foobar as > select date_id,A_table_id,something1 > ,case when something2=x then A1_table.A11 else A2_table.A21 end as foo > ,case when something2=x then A1_table.A12 else A2_table.A22 end as bar > from (... etc., etc. ...)
OK, thank you (the idea is here i will try to do that) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly