|
Posted by --CELKO-- on 07/08/07 14:04
>> How do you combine two SELECT statements from two different tables into one result (assuming both tables have the exact same fields [sic])? <<
The short answer is to use a UNION or UNION ALL.
The right answer is that tables are not files, just as columns are not
fields. If two tables have the exact same structure, then they model
the exact same entity and should be in one table. Files do not behave
that way.
This is usually the result of attribute splitting -- taking the values
of an attribute and making a table for each value.
Navigation:
[Reply to this message]
|