EXEC msdb.dbo.sp_send_dbmail and @query SQL Server 2005

I am using Database Mail, (SQL Server 2005) and would trying to do use the @query function.

1. When an invoice is saved to SQL database
2. A trigger sends an email
3. I have captured the invoice number and tracking number but would also like to capture the details of the invoice line items: Item Number, qty. This information is in a different table than the trigger.

Will this be possible? and if so any suggestions?

Doug