The query would look similar to this:
SELECT tbProducts.*, tbLikeItems.*
FROM tbProducts
INNER JOIN tbLikeItems
ON tbProducts.partno = tbLikeItems.ParentNo
WHERE tbLikeItems.ParentNo = parampartno
variables:
name: parampartno
type: integer
default value: -1
runtime value: $_GET['partno']