Net eSolutions Interview Question

how would i iterate through an array? JOIN statements in SQL