IN vs LIKE operator in Queries

Like:

SELECT AMEX_FEED_MANAGEMENT_03082015.[QC Project Name], AMEX_FEED_MANAGEMENT_03082015.[Release Name], AMEX_FEED_MANAGEMENT_03082015.[Start Date], AMEX_FEED_MANAGEMENT_03082015.[End Date], AMEX_FEED_REQUIREMENT_03082015.[Target Release] AS [Req mapped to Rlease], AMEX_FEED_REQUIREMENT_03082015.[Target Cycle] AS [Req mapped to Cycle], AMEX_FEED_REQUIREMENT_03082015.[Requirement Type], AMEX_FEED_REQUIREMENT_03082015.[Direct Cover Status], AMEX_FEED_REQUIREMENT_03082015.[RRA Analyze Score], AMEX_FEED_TESTPLAN_03082015.[Linked Defects] AS [Test Plan Linked Defects], AMEX_FEED_TESTPLAN_03082015.Attachment AS [Test Plan Attachments], AMEX_FEED_TESTPLAN_03082015.[Test Name] AS [Test Plan Test Name], AMEX_FEED_TESTLAB_03082015.[Target Release] AS [TC mapped to Release], AMEX_FEED_TESTLAB_03082015.[Assigned to Cycle] AS [TC mapped to Cycle], AMEX_FEED_TESTLAB_03082015.[Test Set Name]
FROM AMEX_FEED_TESTPLAN_03082015, AMEX_FEED_TESTLAB_03082015, AMEX_FEED_MANAGEMENT_03082015 INNER JOIN AMEX_FEED_REQUIREMENT_03082015 ON AMEX_FEED_MANAGEMENT_03082015.[QC Project Name]=AMEX_FEED_REQUIREMENT_03082015.[QC Project Name]
WHERE (((AMEX_FEED_REQUIREMENT_03082015.[QC Project Name]) Like ([Forms]![Check QC Project set up]![Text3] & "*")));

or

Select * from Projectstable where project_id like ("PRJ");  -- here it will extract all projects that has "PRJ" in there Project ids.



IN:

SELECT Projects_list.Name
FROM Projects_list
WHERE Projects_list.Name IN (Select Project_ids.Project_Name from Project_ids );
--- IN - operator helps you to look into the list  of values, here it will display list of project names that are available in Project_ids table.