How to Group data with join from other table

Question

I have two tables

Stores=> id,zip_id,stores

Zips => id,zip_code,county,state

the column store in store table is comma separated values , how can i get all the stores states wise.

Answer 1

See if these threads can help,

1. separate comma separated values and store in table in sql server

2. Turning a Comma Separated string into individual rows