KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Consider this table: c_const code | nvalue -------------- 1 | 10000 2 | 20000 and another table t_anytable rec_id | s_id | n_code --------------------- 2 | x | 1 The goal is to have s_id be a computed column, based on this formula: rec_id*(select nvalue from c_const where code=ncode) This produces an error: Subqueries are not allowed in this context. Only scalar expressions are allowed. How can I calculate the value for this computed column using another table's column as an input?
Tags (comma-separated)
Save Edits
Cancel