擅长:python、mysql、java
<pre><code>getresult = """
select i99.serialnumber, i99.size, i99.itemcount, i99.season
from
inventory i99
left join
inventory i1 on
(i99.serialnumber, i99.size, i99.season, i1.season, i99.location, i1.location) =
(i1.serianumber, i1.size, 74, 74, 99, 1)
where i1.size is null
"""
</code></pre>