akerikels46
New member
- Local time
- Today, 16:35
- Joined
- Dec 5, 2020
- Messages
- 1
I have two different tables, the "customers" tables, with "customer ID" as the primary field and a few more fields such as Name, Surname etc. (All in text format).
The second table is "Booking details", It has the primary key as "Booking ID" and then customer name, surname etc, (Again, all in text)
So, basically, in the Booking details table, each booking is given a unique Booking ID, and one customer can do several bookings, i want to create a query that sorts out only customer with more than 3 bookings ? (Without using SQL)
The second table is "Booking details", It has the primary key as "Booking ID" and then customer name, surname etc, (Again, all in text)
So, basically, in the Booking details table, each booking is given a unique Booking ID, and one customer can do several bookings, i want to create a query that sorts out only customer with more than 3 bookings ? (Without using SQL)