I am endeavouring to search across multiple tables in order to compile a search result listing. However some of the table I want to include in the search don't always contain data for a given product, as it is non-applicable.
My problem is once I have connected the tables:
tb_product.int_product_id = tb_contact.int_product_id
if the product in question does not have a contact record, it is left out of the listing as it is considered to be an in complete record.
Is there a way to link tables and include all matching products, with or without contact records, or do I need to go back to using multiple queries to complete the listing?
[int_conatact_id] [int_product_id] [var_contact_name]
1 2 BOB