how woul i write one query that has all of this???

  • Thread starter Nick via AccessMonster.com
  • Start date
R

Rick B

In order to get a good answer, you would need to tell us exactly what you
want. What are the tables, fields, and links that you wish to create?
 
M

Michel Walsh

Hi,


You can't since DDL means Data Definition Language and is used to
define a table, as example, while DML is for Manipulation of the data.

A self join is any kind of join where the table is joined with itself
(as in the case of a hierarchy), etc.


You don't use DDL, DML, neither SELF. Alias, in the other hand, is
generally introduced with the keyword AS, not with ALIAS.


Hoping it may help,
Vanderghast, Access MVP
 
D

Douglas J. Steele

Sounds like a homework assignment that you misread, since, as Michel points
out, it's not possible to use all of those at once.
 
Top