I would use for responding to a data request from another department. I know the basics about table joins and defining criteria for queries, but this question threw me for a loop. Were they just asking to see if I knew those basics, or is there a defined list of database tools out there that I should have been able to refer to?

 

Can you tell me about these things a little more.I dont know about them.