join query

[cpampas]

hello,
I wonder if it is posible to build a join query with two tables, and repeat one of the tables . something like this :

SELECT tblA.name, tblA.score
FROM tblA

UNION SELECT tblB.name, tblB.score
FROM tblB

UNION SELECT tblB.name, tblB.score
FROM tblB;

so, I would join the data in tableB, twice. the query runs OK, but I can only retrieve once the data in tblB
Thanks

 

[pbaldy]

Try changing UNION to UNION ALL

 

[cpampas]

It works great. Thanks a lot

 

[pbaldy]

Happy to help!