Hi! the Code below was Corrected by "microbolt" Its already run but I miss to mention him that I need to add something like instead of order by s.vndrid I need to make order by s.vndrid='" & "s100" & "'"
My purpose is I want only to come out those item under s100.
I missed to mention you this question... Thanks!
as [Item Description], s.Procode as[Item Code], s.Quantity , um
as [UOM], s.sellingprice
as [Price 1],s.vndrid
as [Price 2], priceb
as [Price 3]
from stock s
inner join typediscount t
order by s.vndrid