I have 5 tables saying that each table has Code column along with some other columns. I want to check that whether given code falls in which table?
Please note that code in one table will not exist in another table.
As of now I'm querying each table. If one table does not contain the code it will search in another table and so on. Is this the best option?
Whether I could go for JOIN operation?
Please do suggest me some solution.