Self taught (and poorly at that) on SQL and I ran into something I cannot figure out if it is possible. Given that I have 2 tables: Cust_Info CI Cust_Rev_Info CRI I need to query CI with a child ...

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data.

Editing query nested in another edit. Searches nested fields by wrapping another query. nested field objects are searched as if they were separate documents when a nested query is used.