如何将两个选择与连接相交？ SQL

I have a table with Artists and another with Prints. I want to get everything from the table Artist and just the print_id from the table Prints. Imagine if I have 3 Artists A, B and C. Imagine if artist A and B participated in print 1 and also 2. Artist C participated on print 2 and 3. What I want is the info about artist A and B because they participated on print 1 but also what other prints they participated (in this case, print 2).I have a table with Artists and another with Pr