Query -> select invoice where product detail equal "blah" (1 Viewer)

[mcclunyboy]

EDIT - I have solved this.

I wanted to query a Many-To-Many relationship in an invoice system, I wanted to select all the invoices which included only certain products. However as there were multiple products on the invoices it duplicated the rows. To solve it all I did was create a query to select distinct the invoice_id from the invoice_details record where the products matched my criteria. Then I created another table to join the tbl_invoices to my query based upon the invoice_id

Apologies.