i got two tables and my environment transaction is allowed...

Table A - **ID + Name**

Table B - **ID + Value A+ Value B+ IDTable A**

may i know how to write the query to insert value at once ? hope it can be done within single query...just performance is the highest concern.