Need Help with taking info from two Mysql tables and making a txt file or a table

I posted in the MySql forum and no replies so far.

Here is the scenario. I have two tables, they are cloned from one another. Table A entries are file entries that are needed for a cfg file that I want at the end of all this, there is only 1 row. Table B entries are or will be dynamic. There will be many differernt rows. Here is a very SIMPLE representation of the tables

Table A Table B
id id
templatename templatename
line1type= 12
line1value= 1
line1label= Line 1

The templatename in Table A is empty, not so in Table B. So at the end of this journey I need a file or a table that has a row with the templatename from Table B in templeatename field and that has these:

line1type= 12
line1value= 1
line1label= Line 1
....

entries. There are approx 100 fields in each row. I have looked at various ways to use a Union and a Join Query, but so far I cannot find a way to "Merge" the contents of the fields together. I have not found a way to concat them either. If anyone can help me out I would be very appreciative.

Thanks