Can somebody explain this SQL query to me? what is it doing?
DECLARE @CollectionID int
SELECT @CollectionID= C2.CollectionID
FROM Collections C1
INNER JOIN Collections C2 on C1.CollectionID = C2.ParentID
WHERE C1.Title= '09-0274'
--AND C1.CompanyID= 1 and C2.Title LIKE 'Vendor-' + '240635'
AND C1.CompanyID= 1 and C2.Title LIKE '%240634%'
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…