Mid ADO.NET Use a SQL JOIN query to fetch data from multiple tables.? Review the concept and prepare a concise verbal explanation with a real project example.