syber - 10:19 pm on Jul 21, 2010 (gmt 0)

No, a UNION statement is used to append similar rows from multiple tables. To get the output you want you would need to do a JOIN, however, I don't see the idclient column in the inv or payment tables.