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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster