CodyMonster
Board Regular
- Joined
- Sep 28, 2009
- Messages
- 159
I'm trying to get my head around how to find a situation where I might have a field where two tables match, but, where another field might not.
I'll try and explain this the best I can.
Table 1:
<tbody>
</tbody>
Table 2:
<tbody>
</tbody>
I'm having a hard time thinking of a way a query would spit out that 22046 doesn't have matching ticket numbers.
Maybe this would be easy for someone else. But I'm having a difficult time understanding how to do this.
Thanks for all the help everyone.
I'll try and explain this the best I can.
Table 1:
Lease ID | Ticket Number |
22045 | 100542 |
22046 | 100543 |
22047 | 100544 |
22048 | 100545 |
<tbody>
</tbody>
Table 2:
Lease ID | Ticket Number |
22045 | 100542 |
22046 | 100544 |
22047 | 100543 |
22048 | 100545 |
<tbody>
</tbody>
I'm having a hard time thinking of a way a query would spit out that 22046 doesn't have matching ticket numbers.
Maybe this would be easy for someone else. But I'm having a difficult time understanding how to do this.
Thanks for all the help everyone.