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