Searching ain’t simple
The problem statement is best described using:
This seems like a nice and easy problem, right? We join the architects table to the designs table and we are done.
select d.* from Designs d join ArchitectsDesigns da on d.Id = da.DesignId join Architects a on da.ArchitectId = a.Id where a.Name = @name
This is a trivial solution, and shouldn’t take a lot of time to build…
It is also the entirely wrong approach for the problem, can you tell me why?