Hello, This is the first post I make on this list.
1. I tried to find out wether one can create queries based on more than one occurence of a table. For example, if I only have one table "Names" containing a liat of names (e.g. "Jones" "Doe"), the way to build a query displaying all possible pairs of names would be something like: SELECT names.name names_1.name AS name_1 FROM names, names AS names_1; This works when entered in SQL mode, not in Design mode where it seems that one table can be added only once. Am I wrong? Is it by design? 2. Can I build a query on a query? 3. Can a query create a table or appen rows to an existing table? 4. Not related to queries, but how would you recommend creating a report based on a kexi table or base ? My apologies if those questions have already been answered in this list. I tried to find them bu could not. Thank you in advance, Paul _________________________________________________________________ Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
