dimanche 21 décembre 2014

How to manage two tables in SQL Server


i have two tables offer1 and offer2


The two tables are



Offer1
Offer2ID|OfferName|OfferExpiryDate

Offer2
Offer2ID|OfferName|OfferExpiryDate


now i have third table which keeps record



offersentdetail
offerID|senttime|sentCount|UserID


now i want output sent on Specifc userID


Output will be like


UserID | OfferID | OfferName





Aucun commentaire:

Enregistrer un commentaire