Question: Open the JoinClaimsClaimRepQuery in SQL View. Add a WHERE clause that joins the Claims table and the ClaimsRep table. The common field in both tables
Open the JoinClaimsClaimRepQuery in SQL View. Add a WHERE clause that joins the Claims table and the ClaimsRep table. The common field in both tables is ClaimRepNumber. You will need to qualify the ClaimRepNumber field in the WHERE clause. Run the query, and confirm that the results match those shown in Figure 8 . (Hint: Your records may be in a different order.) Save and close the query. Open the JoinClaimsClaimRepQuery in SQL View. Add a WHERE clause that joins the Claims table and the ClaimsRep table. The common field in both tables is ClaimRepNumber. You will need to qualify the ClaimRepNumber field in the WHERE clause. Run the query, and confirm that the results match those shown in Figure 8 . (Hint: Your records may be in a different order.) Save and close the query
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
