Is it possible to create a select rule that returns results depending on a where clause in the original select statement?
For Example (oversimplified): CREATE TABLE one (data int); CREATE TABLE two (data int); I make the query: SELECT data FROM number WHERE type=1; If the type is 1 (type=1) I want to return 'SELECT data FROM one;' If the type is 2 (type=2) I want to return 'SELECT data FROM two;' Thanks, Chris ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]