Write an SQL query for the following datasets SF_Accounts tblShortToLong 6. Create an update query to find Level 1 keywo
Posted: Thu Jul 14, 2022 2:19 pm
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
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