how do you select from a select statement in sql (micorosft access)?

Question

I want to do a further selection from the result that i go from a pervious SELECT statement.

Answer 1

The following example works for me with Nwind.mdb and Access 2000 (and an Oracle-like syntax):

SELECT *
FROM
(SELECT * FROM Customers where country = 'Germany') t1
WHERE t1.city='Berlin';

Access saves this as:

SELECT *
FROM [SELECT * FROM Customers where country = 'Germany']. AS t1
WHERE t1.city='Berlin';

Answer 2

What do you mean select from a select statement?

Answer 3

Your records format is incorrect. you'll under no circumstances get better complicated queries to artwork. you choose to set up a table youthful little ones(id int() auto_increment, call varchar() ); the accepted secret's the id. then you somewhat choose a table for beverages with an id. then you somewhat can link the guidelines making use of a table with the drink id and the little ones id. this way that is likewise conceivable to have youthful little ones liking better than one drink, and also you merely choose to position in writing queries making use of joins to get better records.

Answer 4

Do you mean a sub-select or criteria?

Criteria:
SELECT title FROM books WHERE author_id = 'Geisel'

SubSelect:
SELECT title FROM books
WHERE author_id = (SELECT id FROM authors
WHERE last_name='Geisel'
AND first_name='Theodor Seuss')

Good Luck!

Answer 5

it depends on what the hell 'sql' is...