Sapiens Technical Lead - Java interview questions

The interview started with the usual 'about yourself' question. Then the architecture of the current project. The interviewer who looked like a technical manager then asked question related to many-to-many relationship query. Since I have mostly worked on Java and very few complex queries, I gave him the concept but was unable to write the exact syntax. That's it, this was the only question he asked. He judged me and my entire knowledge based on one Db question, remind you I was there for Java lead interview.