Write an SQL query for the following datasets
SF_Accounts
tblShortToLong
6. Create an update query to find Level 1 keywords from [tblShortToLong]![Short] field in [SF_Accounts]![Billing Street] field and replace them with [tblShortToLong]![Long] values.
The columns in dataset tblShortToLong look like:
Short:
Fl.
Ave.
Blvd.
Long:
Floor
Avenue
Boulevard
Level:
1
2
Write an SQL query for the following datasets SF_Accounts tblShortToLong 6. Create an update query to find Level 1 keywo
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Write an SQL query for the following datasets SF_Accounts tblShortToLong 6. Create an update query to find Level 1 keywo
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!