I am working with a database application and am currently having a problem in joining the tables..
Table 1 : Materials -- Columns (item_code PK,item_name,p_rate,n_rate)
Table 2 : Projects -- Columns (proj_id PK,proj_name,etc,etc)
Table 3 : Proj_Mat -- Columns (id PK,item_code FK,proj_id FK,qty)
Here Proj_Mat works as the bridge table.. My question is i want the result table as follows when i give the proj_name as input :
Result Table Columns :
Pls help me with this asap :?: