jeudi 2 juillet 2015

Apply join on Result of two tables join for windows phone

I have three tables

POS_ITEM (  have 4  columns [ITEM_col1,ITEM_col2,ITEM_col3,ITEM_col4]) 
POS_MAP  ( have  3  columns [MAP_col1, MAP_col2,MAP_col3])
POS_DIS  ( have  5  columns [DIS_col1,DIS_col2.DIS_col3,DIS_col4,DIS_col5])

my requirement is

i need to perform left outer join for POS_ITEM,POS_MAP..for the result that obtains from the above join ..need to perform join with other table POS_DIS..

what I have implememnted is

  select  b.MAP_col2,a.ITEM_col1,a.ITEM_col2,a.ITEM_col3
 FROM POS_ITEM  as b
left outer JOIN POS_MAP as a on a.ITEM_col1=b.MAP_col2   as h

left Outer JOIN POS_DIS  as d on  d.DIS_col1=h.MAP_col2 ;

the following query not working...

even tried..

(select  b.MAP_col2,a.ITEM_col1,a.ITEM_col2,a.ITEM_col3
 FROM POS_ITEM  as b
left outer JOIN POS_MAP as a on a.ITEM_col1=b.MAP_col2)   as h

left Outer JOIN POS_DIS  as d on  d.DIS_col1=h.MAP_col2 ;

throwing "(" not a valid character error...

please help me regarding this....

Requirement :--result of join of first two tables to be joined with third table..

if you have any other suggestions..let me know...

Aucun commentaire:

Enregistrer un commentaire