Re: parametered views

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