Viewing 2 posts - 1 through 2 (of 2 total)
Instead right click on the "Views" Folder and select "New View", You'll be provided with a GUI to create the query.
May 12, 2008 at 4:08 pm
#814137
Check this..
delete PE
from #prodextend as PE
where exists (SELECT 1 FROM #product PT
INNER JOIN #manu_clients MC
ON PT.client = MC.clientcode
WHERE PE.Din = PT.Din and PE.Pkgsize=PT.pkgsize )
May 1, 2008 at 3:08 pm
#809831