<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E5%B8%B8%E7%94%A8SQL%E7%A8%8B%E5%BC%8F%E7%A2%BC</id>
	<title>常用SQL程式碼 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E5%B8%B8%E7%94%A8SQL%E7%A8%8B%E5%BC%8F%E7%A2%BC"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%B8%B8%E7%94%A8SQL%E7%A8%8B%E5%BC%8F%E7%A2%BC&amp;action=history"/>
	<updated>2026-11-16T22:09:45Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E5%B8%B8%E7%94%A8SQL%E7%A8%8B%E5%BC%8F%E7%A2%BC&amp;diff=3085&amp;oldid=prev</id>
		<title>Root：​新頁面: ==依訂單號搜文件編號== &lt;SQL&gt; SELECT TA001,TA002,TD001,TD002,TD003,TD041,TD004,TD005,TD006,MB029 FROM COPTD JOIN MOCTA ON TA001=&#039;5102&#039; AND TA002=TD054 JOIN INVMB ON TD004=MB001...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E5%B8%B8%E7%94%A8SQL%E7%A8%8B%E5%BC%8F%E7%A2%BC&amp;diff=3085&amp;oldid=prev"/>
		<updated>2018-07-24T02:32:48Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==依訂單號搜文件編號== &amp;lt;SQL&amp;gt; SELECT TA001,TA002,TD001,TD002,TD003,TD041,TD004,TD005,TD006,MB029 FROM COPTD JOIN MOCTA ON TA001=&amp;#039;5102&amp;#039; AND TA002=TD054 JOIN INVMB ON TD004=MB001...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==依訂單號搜文件編號==&lt;br /&gt;
&amp;lt;SQL&amp;gt;&lt;br /&gt;
SELECT TA001,TA002,TD001,TD002,TD003,TD041,TD004,TD005,TD006,MB029 FROM COPTD&lt;br /&gt;
JOIN MOCTA ON TA001=&amp;#039;5102&amp;#039; AND TA002=TD054&lt;br /&gt;
JOIN INVMB ON TD004=MB001&lt;br /&gt;
JOIN COPTC ON TC001=TD001 AND TC002=TD002&lt;br /&gt;
WHERE TD001=2202 AND (TD002=180723022 OR TD002=180723020 OR TD002=180723019 OR TD002=180723007 OR TD002=180720017)&lt;br /&gt;
ORDER BY TA002&lt;br /&gt;
&amp;lt;/SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>