Different type of Joins and Link Type Car Table CarId ModelYear CarBrand Model Mileage ModelYear CarId CA101 2008 Mahindra Scorpio 15 2008 CA101 CA102 2009 Suzuki 800 12 2009 CA102 CA103 2007 Hundai i20 5 2007 CA103 CA104 2007 Toyato Inova 3 2007 CA104 CA105 2009 BMW 5 2009 CA105 CA106 2010 Benz AZ12 10 2010 CA106 Rental Table RentalId CustAccount CarId FromDate ToDate ToDate FromDate RE101 1104 CA101 10/12/2010 10/29/2010 10/29/2010 ...
This blog has posts with AX Developments and X++ Codes for your Day to day use