select M.Mid, M.Name,M.Jianma,M.BuyPrice,M.SellingPrice,M.limtedDate,M.ProductDate,M.Specifications
,M.Manufacturers,M.Tid,M.Uid,M.Supplier,M.Inventory,M.Threshold,T.Type,U.Units from Medicine as M inner join Type as T on M.Tid=T.Tid inner join Units as U on M.Uid=U.Uid
,M.Manufacturers,M.Tid,M.Uid,M.Supplier,M.Inventory,M.Threshold,T.Type,U.Units from Medicine as M inner join Type as T on M.Tid=T.Tid inner join Units as U on M.Uid=U.Uid
,M.Manufacturers,M.Tid,M.Uid,M.Supplier,M.Inventory,M.Threshold,T.Type,U.Units
from Medicine as M ,Type as T,Units as U
where M.Tid=T.Tid and M.Uid=U.Uid
,M.Manufacturers,M.Tid,M.Uid,M.Supplier,M.Inventory,M.Threshold,T.Type,U.Units from Medicine as M inner join [Type] as T on M.Tid=T.Tid inner join Units as U on M.Uid=U.Uid