Hello Andrew,
Andrew Jensen schrieb:
Hello Regine,
[..]
Also, you can do this with the query designer
I thought you could do it directly by adding the Personen table twice,
but that does not work, so what you do is use the Query-in-Query
feature to get this.
-- Create a query that simply selects all fields from Personen and
save it. ( qChef is what I used )
-- Now open a new query designer
-- Add the table Personen
-- Add the QUERY qChef
-- Add the join by dragging Personen.ChefID to qChef.ID
-- Add the fields with aliases as needed
-- Save
The result, for me using English, is identical to the your two SQL
statements here.
Thanks, that works in design view. In addition I have tried using a view
instead of the query; that works in design view too.
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
