While or Some Select ?

[Lukas]

Hi all

A have a problem with access query.
This is exemple what I want

I have two tables

Table1 - Product Table2 - Features
ID_product Param ID_features Param
P1 X1 F1
X1
P1 Y1 F1
Y1
P1 Z1 F2
Z1
P2 X1 F3
Y1
The way verification
<<--
Problem is:
1) Select some features and its Param
2) If this ALL Params (this one Features) are CONTAINS in Prams some Product,
take this Features

I want to get this Results

Some New Table
ID_product Features
P1 F1
P1 F2
P1 F3
P2 NULL

Any Idea??

Thanks

 

[Lukas]

Corect format

 

[Lukas]

Table1 - Product Table2 - Features
ID_product Param ID_features Param

P1 X1 F1
X1
P1 Y1 F1
Y1
P1 Z1 F2
Z1
P2 X1 F3
Y1
The way verification
<<--
I want to get this Results

Some New Table
ID_product Features
P1 F1
P1 F2
P1 F3
P2 NULL