What is the meaning of this query?

[doci4a]

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

[orange]

I don't recognize the format/syntax. It almost looks like someone building a query in vba, but it isn't that either.

Where did this query come from? What is the context?
What do "cc", "cg" and "fr" represent?

[doci4a]

I don't recognize the format/syntax. It almost looks like someone building a query in vba, but it isn't that either.

Where did this query come from? What is the context?
What do "cc", "cg" and "fr" represent?

It was out of the context sorry...irrelevant topic.

Thank You