I have a table with a transactionID that has a payment type field for cash and card i.e. ID 1 payment type cash, ID 1 payment type card. These are 2 separate records. How do I create a query where I can identify the ID which has both cash and card payment type? Some ID only have cash; some only...