elect OriginalItemNumber, ItemNumber, Original.Style, OriginalName, Original.Description, Medium, Original.Dimensions as ODimensions, Prints.Dimensions as PDimensions, Original.Price as OPrice, Prints.Price as PPrice, Sold, Quantityonhand from Original, Prints where OriginalName = PrintName and Original.Style='florals' order by OriginalItemNumber"