Hi guys,
As I have limited experience in SQL, I would like to know what does the following query mean?
SELECT ASSOCIATE_ID FROM HR_ASSOCIATE_DATA
WHERE CCID = " & cc & "
AND GROUP_CODE = '" & cg & "'
AND FIRM = " & fr & ";"
I know what "cc", "cg" and "fr" represent.
What I don't understand is what the "&" symbol does.
And why in the CCID line there are double quotes only and in the GROUP_CODE row there are single quotes and then double quotes.
Thank You for your time