Hi :) I think the tables that have information for only some of the 'people' in Table A need to have a dummy record to cover that case.
So you might have 1 row of all zeros, or whatever is suitable to indicate a lack of data. Then all the people with no data just point to that single row. Err, i have a feeling you have already done that but it's the simplest thing that might have gone wrong. Regards from Tom :) On 14 May 2014 14:54, Victor <[email protected]> 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 > 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: [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 > > -- 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
