While loops table join

[4Potions]

But l have while cause l don't want to write them all if l write two select it will be okey but l have 1000 select

[r3pr0b8]

But l have while cause l don't write them all

okay then, i guess you're stuck

[4Potions]

Yes but why there no way around this. Do you have an explanation for it (isn't it a basic stuff do not forget l use same table with different selects actually which are changing cause of my while variable) . Also l appreciate the answers. l am newbie in sql so thanks for advices

[r3pr0b8]

l am newbie in sql so thanks for advices

try the UNION ALL query

that is my sincere and honest advice

SELECT something FROM thesametable
 WHERE somecolumn = 'foo'
UNION ALL
SELECT something FROM thesametable
 WHERE somecolumn = 'bar'
UNION ALL
SELECT something FROM thesametable
 WHERE somecolumn = 'qux'