SELECT ClassName,ClassDescription,MapEmbed,ClassStart,ClassEnd,Address1,Address2,City,State,Zip,RegistrationFee,FeeText,ClassID, concat('/Checkout.html?thisIDname=ClassID&thisIDvalue=',Cast(ClassID as char)) as CartLink FROM rd_class_data,rd_location_data WHERE rd_class_data.LocationID = rd_location_data.LocationID and rd_class_data.ClassID = '337'; SELECT DayOfWeek,Timetext,ItemOrder FROM rd_classday_data WHERE classID = '337';