[libreoffice-users] Re: Tell me it's not true

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: users+unsubscribe@global.libreoffice.org
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