SQL Problem

#11

In article <1d584d94-8944-437d-b6f0-6bfd4e2407f6 (AT) r20g2000yqd (DOT) googlegroups.com>, bruce <bruceaj (AT) bellsouth (DOT) net> wrote:

Quote:

I guess it's my inexperience but I cannot figure out how to write SQL
for the following case:

I have two tables. Table1 has the numbers 1 through 100 (no
duplicates). The Table2 has "Some" of the numbers 1 through 100 and
there may be duplicates in Table2. I would like to SELECT a list of
the numbers missing from Table2.

And to carry it one step further. I want to use the numbers missing
from Table2 to SELECT the rows from TABLE 1 with these numbers. This
is the final result.

SELECT Table1.Number, Table1.OtherColumns
FROM Table1 LEFT JOIN Table2 ON (Table1.Number = Table2.Number)
WHERE Table2.Number IS NULL
;

#12

On 2011-05-06 01:02, Geoff Muldoon wrote:
[...]

Quote:

RTFM on the use of the MINUS function

AFAIK mysql does not implement minus (which is a set operation in other
dbms, not a function). Can you be more specific on where to read up on this?

/Lennart

#13

erik.lennart.jonsson (AT) gmail (DOT) com says...

Quote:

AFAIK mysql does not implement minus (which is a set operation in
other
dbms, not a function). Can you be more specific on where to read up on this?

Ah yes, my bad.

Forgot that MySQL doesn't implement the ANSI standard (actually in the
ANSI standard it is called EXCEPT instead of MINUS, which is and Oracle-
specific ontology) in this area.

GM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Problem

comp.databases.mysql comp.databases.mysql

Re: SQL Problem - 05-05-2011 , 09:12 PM

Re: SQL Problem - 05-06-2011 , 12:58 AM

Re: SQL Problem - 05-08-2011 , 06:28 PM