Fetching data from two tables

[deegeorge]

Hi,
I have two tables having same column names. one table name is auditrial and other is deleteasset.Bot h tables have one same column named assetid.suppose 111 is inserted into the table audittrial. and again if the user is attempting to enter the same id it need to search both the tables. and if it is there in any one table it should fetch that id. Pls reply fast