why doesn't the following work?
mysql> select * from girls full outer join boys where girls.city = boys.city;
where :
drop table girls;

Does DB2 not support Multi-versioning?  Now SQL Server 2005 also has
Snapshot Isolation. [bis 8 nicht, 9 glaube ich auch nicht, vielleicht Viper2?]
See
http://technet.microsoft.com/en-us/library/ms345124.aspx

I wonder instead of just brainstorming, there probably is
a very standard and a simple way to do database schema design.
let's say we are doing a website.  the user can go over
and type in the movie name and zipcode, and the website

Watch Meet Your Meat:
http://www.petatv.com/tvpopup/Prefs.asp?video=meet_your_meat
Vegetarianism for health:
http://goveg.org/healthConcerns.asp

Autonum fields for generating primary keys are limited to 2^32 (10^10)
keys. It is my understanding that they are not reused. What happens
when the last key is generated and then an attempt it made to add
another record?

To I have the following tables:
groupleaders, workgroups, employees
employees,
first name

I am developing a payroll app. I have an EmployeeMaster table which
contains field EmpID P.K, and EmpCode Unique. At present whatever
details I have, the EmpCode is a long numeric value that the
department is managing internally.

With mainframe indexed files (VSAM) and DL/I (IMS) databases segments, which
are somewhat analogous to rows in a table, are pretty much just, umm, large
chunks of data.  If you want to replace a segment with new values for one or
more fields you must replace the entire segment.

I have few queries regarding the use of Stored Procedures, Functions
and Triggers in an RDBMS.
(1) When to use Stored Procedure? Writing an INSERT query in a Stored
Procedure is better or firing it from the application level?

This is a common question on forums. But they just compare the
features. At present RDBMS industry has matured a lot and the big
three have strong competitors too like EnterpriseDB, MySQL etc.
While comparing MS SQL Server, Oracle and DB2, an author writes in a

I am trying to design a database model related to the small world (or six
degree of separation) phenomenon.
With this design, I should be able to write two queries efficiently:
a)      How many degrees of separation are there between two people.

IBM owns two products, Informix and DB2. What is the difference
between the two and how reliable are they for very large databases?
Are they focussed for any specific area?

Wow is it quiet in here. How about a quick survey of the expertise
here?
What databases are you using now (now meaning the last 5years or
less)?

I am looking for a public database of federal EINs for U.S. corporations and
the equivalent for corporations based in France, UK, Germany and other
European countries (as well as Japan) to use as primary keys in a database.
Does anyone know of such databases? I do know that I can ...

let's say I have a mapping table with columns A', B' and C'
and let's say I have a data table with columns, A, B, C, D, E, F
Now, what I want to do is update the data table with C' if A=A' and
B=B'