Hi again.

I can get my data with left join but that also returns 2 blank rows??

Here is some sample data:

sample data

PRODUCTS

productID generic fields.......

12

13

15

18

19

20

35

36...

"Thus there are no product id's in bikes that are also in parts?"

yes. that is the case.

I have tried left join now. Looks good! Will let you know how I...

Hello.

Thankyou for the suggestion.

However the parts table is totally unrelated to the bikes table so I cannot inner join from bikes.product_id to parts.product_id as there are no matching values.

Both tables...