Re: [libreoffice-users] Help with LO Base

On 14/05/2014 15:54, Victor wrote:
> Hello.
>
> I'm a new user of LO Base, and I have some problems that I haven't be able
> to solve with tutorials.
>
> I'm making a db with several tables with many records in each one, and I
> want to retrieve records from several tables at the same time. Let me
> explain my problem:
>
> I have a "table A" with about 12000 records, with their IDs 1-12000. Then I
> have other tables where some of those records have more data, and some
> records are not present. I mean, in Table B, there are records 1-1000, in
> table C 1001-2000, not necessary in that orther, but the point is that some
> records are present in the tables are some aren't.
>
> When I try to retrieve data from several tables, I'd want to have all the
> records, no matter if they are present in all the tables or not.
>
> I don't know what kind of relationship I need to create so when I run a
if you made a INNER JOIN then you have only the data who there are 
records in both tables
if you made a LEFT OUTER JOIN you will have all records  in the left 
table + all records (also the empty in the right table.

so start the selection (left) with the table where all records are 
present and join to tables with aditional information
> query to retrieve data from many tables at the same time, if a record is not
> present in a table, then the columns for that record in that table should be
> empty, but instead of that i'm getting things as the correct data from table
> A, but then in table B I only get one record repeating in all the rows.
>
> I hope I've explained myself clearly enough so you can help me.
>
> Thank you very much.
>
>
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Help-with-LO-Base-tp4108795.html
> Sent from the Users mailing list archive at Nabble.com.


--
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