i am having 2 separate columns(‘list_id’ and ‘list_index’) in 2 different tables(‘transaction_logs’ and ‘payment_logs’) of same db (plogs).
i am retrieving both columns with a concat statement eg. (ATS-1023). Now i want to add a field filter on this retrieved column. but i don’t know how?
You’ll have to use a database view for that.