Simple Select Query - help

[rj]

Hi,

I'm doing a select query that looks at two seperate
tables. The first table it looks at contains the list of
manufacturers i want to pull from the second table.

SELECT *
FROM Sheet1
WHERE (((Sheet1.line)=[lines]![line]));

I'm obviously not doing something right because it prompts
me for a parameter value.

Any help is appreciated,

Thanks

 

[Michel Walsh]

Hi,


SELECT sheet1.*
FROM sheet1 INNER JOIN lines
ON sheet1.line = lines.line



Hoping it may help,
Vanderghast, Access MVP