Can I join multiple lists in SharePoint Query with conditions?

Question

I want you guys to clarify to me if SharePoint lists can be handled as Tables in Sql? Am I allowed to use join? and conditions on that query?

Answer 1

Yes you can use CAML in SharePoint to apply conditions and even join multiple lists in SharePoint

But if you have too much relational structure than I will suggest you to use SQL Server and ASP.NET application instead.

SharePoint can't handle large data and too many relations very effectively.

CAML Query tutorial for SharePoint

List joins and Projections