sql query to link invoice payments to invoice id?

[Jannick Asmus]

Hi,

I am trying to identify the invoice payments TOGETHER with the 
associated invoice in the sqlite file of my GnuCash file. Since there is 
a window to process the payment, I suspect there should be a link 
between the payment and the invoice guid.

I am aware that the payment amount need not be identical to the invoice 
amount. As there might be slight differences between these two amounts 
in reality anyway, I prefer not to have a query using the invoice 
amount.

Any ideas on this highly appreciated!

/J.