SachAccess
Active member
- Local time
- Today, 16:39
- Joined
- Nov 22, 2021
- Messages
- 389
Hi Experts,
I need to your help to understand two queries. Values in the queries are dummy.
Will take help from here for 2 queries and will try to use the knowledge to understand rest of the queries.
Was able to understand few basic things from below but was not able to understand what and how exactly below statements are working.
Kindly help me to understand, how to break these statements and draw conclusion.
Thanks.
I need to your help to understand two queries. Values in the queries are dummy.
Will take help from here for 2 queries and will try to use the knowledge to understand rest of the queries.
Was able to understand few basic things from below but was not able to understand what and how exactly below statements are working.
Kindly help me to understand, how to break these statements and draw conclusion.
Thanks.
Code:
SELECT Table_My_123.My_Rank, "String_1" & [Table_My_123].[My_Col_1] & "String_2" & [Table_My_456].[My_Col_2] AS Comment
FROM Table_My_123 LEFT JOIN Table_My_456 ON Table_My_123.My_Rank = Table_My_456.[Chassie_Number]
WHERE ((([Table_My_456].[My_Col_2]=[Table_My_123].[My_Col_1])=0));
UPDATE Table_My_123 LEFT JOIN Table_My_456 ON Table_My_123.My_Rank = Table_My_456.[Chassie_Number] SET Table_My_123.My_Col_1 = [Table_My_456].[My_Col_2]
WHERE ((([Table_My_456].[My_Col_2]=[Table_My_123].[My_Col_1])=0));