Select {tableName}.* from {tableName} not working

[t0rton]

I'm trying to Select {tableName}.* from {tableName} not working when I join 2 tables becase I just wanna return the values from first table example

db.select('p.*').from('products p').join('brand b', 'b.id=p.brand_id')