Hello there,
I have database called X, X database is master database with all records and has Master table and has column called Status which can have value of "New", "Old", "Repair" as first three letters.
Now my query is that I want to create database Y which would hold only those records of X database's "master table" who has column which has "NEW" as first three letters. I want to keep appending these records from X database to Y database after some intervals.
Can anybody please help me on this ?
Thanks
DD
I have database called X, X database is master database with all records and has Master table and has column called Status which can have value of "New", "Old", "Repair" as first three letters.
Now my query is that I want to create database Y which would hold only those records of X database's "master table" who has column which has "NEW" as first three letters. I want to keep appending these records from X database to Y database after some intervals.
Can anybody please help me on this ?
Thanks
DD