coookiemonsterm
New member
- Local time
- Today, 00:00
- Joined
- May 11, 2022
- Messages
- 1
Hi there, I have a database setup with a Tickets table and a customers table.
These have a 1 to many relationship and I've attached a screenshot of the tickets table showing how it looks
When I'm running a query to show everything from the ticket table, if the Customer_ID is blank, then these don't appear. I have no conditions, no filters, no nothing. Please can someone tell me where I'm going wrong?
What the query is showing:
These have a 1 to many relationship and I've attached a screenshot of the tickets table showing how it looks
When I'm running a query to show everything from the ticket table, if the Customer_ID is blank, then these don't appear. I have no conditions, no filters, no nothing. Please can someone tell me where I'm going wrong?
What the query is showing: