bear in mind that different join types return different results.
with an inner join, a result will only be returned if there is a match on both sides of the join predicate.
with the number of tables that you are joining, I'm going to bet that at least one of the join pairs is not making a match so is not returning a result.
to trouble shoot, change the select to:
SELECT *
then add one join at a time:
FROM LEDprods
INNER JOIN LEDcats ON LEDprods.LEDcatID = LEDcats.LEDcatID
test that then add the second:
FROM LEDprods
INNER JOIN LEDcats ON LEDprods.LEDcatID = LEDcats.LEDcatID
INNER JOIN LEDchips ON LEDprods.LEDchipsID = LEDchips.LEDchipsID
test again and so on.
once you stop getting a result revert to a simpler query with only the last join that you added.
your jumping in on the deep end with such a complex query. Get your feet wet with something simper first.
also look into a GUI SQL Tool such as Heidi SQL for building queries with a visual builder.
