Sorry, is there any way to solve this problem?
OU L 在 2024年2月14日 星期三下午3:59:25 [UTC+8] 的信中寫道:
> The current query we use retrieves customer IDs with Level 2 information.
> However, is it possible to simultaneously query data for Level 2 and
> identify the corresponding Level 1 parent customer ID
The current query we use retrieves customer IDs with Level 2 information.
However, is it possible to simultaneously query data for Level 2 and
identify the corresponding Level 1 parent customer ID?
SELECT customer_client.client_customer, customer_client.level,
customer_client.manager, customer