Brand New to qSql

[Laura]

If its an exact match you can use Match Each ~'.

 

select from data where childID ~’ parentID

 

 

[davidcrossey]

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