sql - Select multiple columns from multiple tables? -

i have 3 tables in sql

ptable:

prdnum 1 2 3 4 5 6 7 

qtable:

prdnum        pid             data  1              1             somedata 1              2             somedata 2              1             somedata 3              1             somedata 3              2             somedata 4              1             somedata 

stable:

prdnum                      brand 1                           somedata 2                           somedata 3                           somedata  4                           somedata   

the prdnum primary key. here need select prdnum ptable , brand belongs prdnum stable , data qtable belongs prdnum, , condition prdnum don't having pid=2 in qtable.

i tried code like

select prdnum  ptable  prdnum not in (select prdnum qtable pid=2)  

but how can select brand , data other tables?

select p.prdnum, s.brand, q.data ptable p join stable s on p.prdnum = s.prdnum join qtable q on p.prdnum = q.prdnum q.pid != 2