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')