Mark Stanton <mark <at> vowleyfarm.co.uk> writes: > > When I select the dBase connector it seems to say that queries cannot > contain more than one table. > > Tekll me it's not true... > Mark Stanton > One small step for mankind... >
Mark, it IS NOT TRUE. I have routinely used ~25 tables, and run queries using 3 or more tables. I find it most useful to structure my queries using the SQL command line rather than the "wizard", although it can be done using the "wizard" also. I am running Linux, and I use PostgreSQL for my database engine, and the Java JDBC Driver. An example two table query is: SELECT DISTINCT "VenIndLoc".*, "Products".* FROM "All_IPO-wi_Industry_Location" AS "VenIndLoc", "wms"."Products" AS "Products" WHERE "VenIndLoc"."CO_NAME" = "Products"."COMPANY" ORDER BY "VenIndLoc"."CO_NAME" ASC, "VenIndLoc"."INVEST_NO" DESC where the two tables used are "VenIndLoc" and "Products". Hope that helps. Cheers, --Bill -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
