I have a table promotion_schedule that has a field called "where clause". This actually has the where clause used to pull certain items out of another table. If I do a:
select where_clause from promotion_schedule
it will give me the following:
((acntv.master_sku.retail_cat='some value',prod_type='some value').
What I need to do is get all the items from the master_sku table that have those criteria. Or
select * from acntv.master_sku where (select where_clause from promotion_schedule).
Does this make any sense at all. It keeps giving me an "invalid expression" message. I understand I cant do it as I've written as above, but not sure how to actually accomplish it. Any help is greatly appreciated.
select where_clause from promotion_schedule
it will give me the following:
((acntv.master_sku.retail_cat='some value',prod_type='some value').
What I need to do is get all the items from the master_sku table that have those criteria. Or
select * from acntv.master_sku where (select where_clause from promotion_schedule).
Does this make any sense at all. It keeps giving me an "invalid expression" message. I understand I cant do it as I've written as above, but not sure how to actually accomplish it. Any help is greatly appreciated.