Hi I have these two tables:Customers and Bookings;Customers has these fields CustomerId,firstname,lastname etc.Table bookings has bookingId, customerId,datebooking,startdate,enddate etc.I want to retrieve customerId,first and last name from Customers and datebooking,start and enddate from bookings, I understand I have to use a LEFT JOIN.I tried everything but it does not work, coud someone give me the right code for this? I am running MySQL 5.4.
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.