Hi Everyone,
i have four field in the database Field 1,Field 2,Field 3,Fields 4
Here Field 3 is subset of Field 2 & Field 2 is subset of Field 1 & Field 4 is Date & rest all fields are Numbers. Now i need to add Field 5 which will be a status where i need to update this basis an update query.
Update Query will be a nested query which will assign Status " New " to all those records where the record under Field 3 and date under Field 4 got inserted for the first time since you will have records with Different date under Field 2.
Example
Field 1 Field 2 Field 3 Field 4 Field 5
1 101 1001 1/5/2016 New
1 102 1002 1/21/2016 New
1 102 1003 2/5/2016
1 102 1004 3/15/2016
2 105 1005 1/11/2016 New
2 105 1006 2/17/2016
2 105 1007 3/15/2016
2 105 1008 4/20/2016
i have four field in the database Field 1,Field 2,Field 3,Fields 4
Here Field 3 is subset of Field 2 & Field 2 is subset of Field 1 & Field 4 is Date & rest all fields are Numbers. Now i need to add Field 5 which will be a status where i need to update this basis an update query.
Update Query will be a nested query which will assign Status " New " to all those records where the record under Field 3 and date under Field 4 got inserted for the first time since you will have records with Different date under Field 2.
Example
Field 1 Field 2 Field 3 Field 4 Field 5
1 101 1001 1/5/2016 New
1 102 1002 1/21/2016 New
1 102 1003 2/5/2016
1 102 1004 3/15/2016
2 105 1005 1/11/2016 New
2 105 1006 2/17/2016
2 105 1007 3/15/2016
2 105 1008 4/20/2016