I want to update the fact that I have printed a member cards for new memberships baseed on the date of a membership in a child table.
update members set cardprinted='Y' from select m.*, c.* from members as m join memberships c on m.memberid= c.memberid where c.join_date > '11/7/2013'
This gives an error, and I can't find any examples that show how to do this. Take the "update members set carprinted='Y' from out and it pulls up the members correctly that need to have a new member cards that have been printed.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.