SELECT TROUBLES

[pondi]

Here are my 2 tables
ELEMENTS
id
name
type

ELEMENTLINKS
id
n1
n2

n1 and n2 are ids of 2 linked elements. I'd like to display a 2 columns-result:
ELTTYPE1 ELTTYPE2
Note: An Elttype1 is linked to many elttype2 but i'd like to have the full list of dependencies like

elt11 elt21
elt11 elt22
elt12 elt26
elt12 elt27
...

But i can't see how to start the query, like select name, name from elements.????????

Thanx for your help.

 

[tlbroadbent]

See answer in thread701-124990 of the Access forum. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.