I have to work with two tables - Service Request Table and Audit Talble in order to get the data I need.
One of the fields in the Service Request Table contains a field named: Service_Request_No. The data in the Service_Request_No field shows the serv. req. no in the following format:
00000000000000000000000000000004491388
One of the fields in the Audit Table contains a field named: KEY_INFO. The data in the KEY_INFO field contains the same data as the Service_Request_No field, but the data is in the following format: 4491388 (in this format, the 32 leading zeros are not used).
Also, these two particular fields are the only fields that could join the tables because they are the only common fields. Also, these tables are linked tables.
If I want to run a query to search TN_NPA, TN_NXX and TN_LINE from the Service Request Table and the User_ID from the Audit Table, how would I do that and get the Srv_Req_No and KEY_INFO fields to match up?
Please help. Thanks.
One of the fields in the Service Request Table contains a field named: Service_Request_No. The data in the Service_Request_No field shows the serv. req. no in the following format:
00000000000000000000000000000004491388
One of the fields in the Audit Table contains a field named: KEY_INFO. The data in the KEY_INFO field contains the same data as the Service_Request_No field, but the data is in the following format: 4491388 (in this format, the 32 leading zeros are not used).
Also, these two particular fields are the only fields that could join the tables because they are the only common fields. Also, these tables are linked tables.
If I want to run a query to search TN_NPA, TN_NXX and TN_LINE from the Service Request Table and the User_ID from the Audit Table, how would I do that and get the Srv_Req_No and KEY_INFO fields to match up?
Please help. Thanks.
