Hi Guys,
I have created a new table which has replaced the old tables due to business needs. Now my report is not pulling through the historical data as it's pointing to the new table. How can I change my query so it will check reference number in old table and if it's there then pull through the data and if it's not then check in new table.
Can we do something similar?
Thanks
I have created a new table which has replaced the old tables due to business needs. Now my report is not pulling through the historical data as it's pointing to the new table. How can I change my query so it will check reference number in old table and if it's there then pull through the data and if it's not then check in new table.
Can we do something similar?
Thanks