i answered a different question. Should have read the question better. mwasif got it right

Oh. So thats what it feels like to look like an idiot. I forget if I go more then 20 minutes without putting my foot in my mouth. I'll read more carefully next time

if they are all coming from a single table...call it testTable... then you would just say


SELECT location1, location2, location3 FROM testTable WHERE ....

and then you can fill in whatever...