I am doing a sales company in a credit card record table has a "card number", "swipe time", "consumption amount" in another set table, "Dining Category", "Start Time", "End Time", It is also early, medium and dinner time range settings. How do I generate a computational column in the record table when querying, showing the "Swipe Time" Dining Category within the corresponding time range?
The result is similar to the following form
Card number swipe time breakfast consumption amount card number swipe time Chinese consumption amount card number swipe time dinner consumption amount
Thank you! ! !
