select category.name,product.* from product join category on product.category_id=category.id where product.category_id='2'

World's Most Affordable Neon Signs - Unbeatable Prices

Free Shipping Worldwide

Exclusive Quality & Personalized Craft

Account

SHIPPING! Continue shopping to add more products and receive free shipping

Go To Cart Check out

Templates

Merry Christmas