Select Char(D.UPC), A.Supplier_num, C. dept_num, Char(A.Supp_Location_code), Char(A.Decl_Avail_Qty) from
Tablename A, Tablename B, Tablename C, Tablename D
Where A.Supplier_num = b.supplier_num
And A.Part_id= B.Part_id
And D.Part_id= C.Part_id
And A.stroke_number = B.Stroke_number
And D.Prim_size_index = A.Prim_size_index
And D.sec_size_index = D.Sec_Size_index
And A.Colour_code= B.Colour_code
And B.Supp_location_code in (1,4,2,5)
And B.Supplier_num in (â€˜2080â€™,â€™2897â€™,â€™7658â€™â€¦â€¦â€¦..)
In this query I want to include supplier_num as 9285 with supp_location_code as 3 and 6,
But problem is that if I include these 3 and as supp_location_code in above query it will fetch data for these supp_location_code for other suppliers also.
I need only 9285 with 3 and 6 location code and other suppliers with 1,2,4,5 location codes.If u can find then let me know.
Can anybody help in out...
Thanks in advance.