Did you know ... Search Documentation:
CQL: Self JOIN