Re: [users] Base Queries

2007-02-25 Thread CPHennessy 
On Saturday 03 February 2007, Ron Ferguson wrote:
> Please can someone point me to detailed instructions on the use of queries,
> or resolve the following problem. I have read the Getting Started
> documentation and have no problem with it but it does not answer my
> problem.
>
> I have two large tables in a database converted from Access, A and B. Table
> A contains 3 fields 2 of which I am interested in , namely ID, y and z.
> Similarly table B also has 3 fields ID, w and x.
>
> In Table A field z I can insert a number which gives me a list of all
> instances for the equivalent field in field y. This field then becomes
> field w in table B and I wish to know all instances in field x that the
> output in field y (=field w) occur. Please note that the fields y and w do
> not have the same title.

If your question has not yet been answered, you could ask on 
dev@dba.openoffice.org ( remembering to subscribe ).

-- 
CPH : openoffice.org contributor

Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] Base Queries

2007-02-03 Thread Ron Ferguson 

Please can someone point me to detailed instructions on the use of queries, or 
resolve the following problem. I have read the Getting Started documentation 
and have no problem with it but it does not answer my problem.

I have two large tables in a database converted from Access, A and B. Table A 
contains 3 fields 2 of which I am interested in , namely ID, y and z. Similarly 
table B also has 3 fields ID, w and x.

In Table A field z I can insert a number which gives me a list of all instances 
for the equivalent field in field y. This field then becomes field w in table B 
and I wish to know all instances in field x that the output in field y (=field 
w) occur. Please note that the fields y and w do not have the same title. 

I hope this is clear, Thank you.

Ron Ferguson