Maybe it's because it's Friday but I can't seem to get this and it feels like it should be really really easy. 

I have one result set (pulls the data from multiple tables) that gives me the following result set: 

Room Type | ImageID | Date

The next query (pulled from separate tables than above) result give me : 

ImageID | Date | Tagged

I just want to compare the results to see which imageid's are common between the two results, and which fall into each list separately. 

I have tried insert the results from each into temp tables and do a join on imageid but sql server does NOT like that. Ideally I would like a solution that allows me to do this without creating temp tables. 

I researched using union but it seems that because the two results don't have the same columns I avoided that route. 

Thanks!