KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ Brand New to qSql Re: Brand New to qSql

  • davidcrossey

    Member
    May 9, 2022 at 12:00 am

    If it’s not an exact match, you could wrap the second column in wildcards characters and use Like Each like'

    select from data where childID like’ (“*”,’parentID,'”*”)

    Note – this assumes that the parentID has less characters than childID