Which of these 2 queries should I use?

[shapper]

Hello,

I am trying to figure out what are the differences between a query in
SQL and Access.
I am having problems with my Access query.

Which one should I use?

SELECT content_localized.content_html
FROM content INNER JOIN content_localized ON content.content_id =
content_localized.content_id
WHERE (((content.content_page)=? AND ((content.content_name)=? AND
((content_localized.content_culture)=? ));

or

SELECT content_localized.content_html
FROM content INNER JOIN content_localized ON content.content_id =
content_localized.content_id
WHERE (((content.content_page)=[@Page]) AND
((content.content_name)=[@Name]) AND
((content_localized.content_culture)=[@Culture]));

and why?

Thanks,
Miguel

 

[David Cox]

Since this is an Access group I think it fair to assume that you should use
an Access Query.

In Access to prompt for a value you simply enclose the prompt text in []
thus:
WHERE (((content.content_page)=[gimme a page, pls.]

 

[Jerry Whittle]

First pick the sql statements that return the correct records. Then from
those statements pick the sql that runs the fastest.

You say that you are having problems with the Access query. What problem?