Name: [1922] Dai
Member: 108 months
Authored: 131 videos
Description: Hi I'm Dai Just an ordinary guy with an interest in computers who likes making how to videos for others to get the best out of there computers. I ounce did a course on web-design to further my interest in the subject. Got a HNC out of to boot but, lately my interest has turned to doing howto vide ...

Changing The Join Type [ID:344] (12/15)

in series: OpenOffice Base

video tutorial by Dai, added 08/07

(Showmedo is undergoing major changes. To report any problems viewing the videos please email us and include browser and OS specifics. Cheers - Kyran.)

How to change from an Inner join to a left join in Base

Got any questions?

Get answers in the ShowMeDo Learners Google Group.

Video statistics:

  • Video's rank shown in the most popular listing
  • Video plays: 166 (since July 30th)
  • Plays in last week: 1
  • Published: 109 months ago

Thank-yous, questions and comments

If this video tutorial was helpful please take some time to say thank-you to the authors for their hard work. Feel free to ask questions. Let the author know why their video tutorial was useful - what are you learning about? Did the video tutorial save you time? Would you like to see more?

You may also want to see our ShowMeDo Google Group to speak to our active users and authors.

Your email address will not be published.

Show some quick comments >>

All comments excluding tick-boxed quick-comments

17. polo ralph lauren shirts clearance Sat, 11 Sep 2010 02:51


16. Tihothy4kzs Thu, 17 Jun 2010 22:13

This is GREAT on 1 to 10 it is a 12! Thank You. I found this site needed help with open office I can not thank you enough and check out the other subjects

15. new balance,new balance shoes,joe's new balance,new balance outlet Sat, 22 May 2010 23:41

Very good and useful

14. anonymous Sun, 15 Nov 2009 15:43

Like it. nice and easy to follow.

I am looking how to auto deduct numbers. ie inventory of 12, someone buy 2, inventory now = 10

can you help?

13. anonymous Sun, 25 Oct 2009 19:33

Sorry but I understood what you accomplished but nothing about what you did "Inner Join" "Left Join" has not come up in anything I have read so far and this didn't explain it

12. anonymous Wed, 12 Aug 2009 14:01

Nice but Limited. Do you know where to find a "Northwest" for Base?

11. anonymous Fri, 17 Jul 2009 12:18

Great introduction to designing databases

Wow. It was so great query manipulations or updating. Thanks for the help.

9. anonymous Sat, 06 Jun 2009 01:15

I'm watching all of your videos on creating a database & they are very helpful & informative.

8. anonymous Wed, 13 May 2009 13:57

For some time I've been struggling with the built-in help pages belonging to The story told and shown by a teacher is much more helpfull. Thank you!

6. anonymous Sat, 28 Mar 2009 12:37


Thanks for the tutorials, they really help me to start my experience with openoffice base. Somebody knows how to SUM a column in a report ? I want the SUM of something to show in the bottom of my report.

Thanks a lot again!

5. anonymous Wed, 25 Mar 2009 09:13

Briliant, thanks. The pace is spot on for me - gives me time to think and let things sink in. These videos have been a huge help to me and I appreciate your effort.

4. anonymous Sat, 21 Mar 2009 10:07

Helps to clarify things quite a bit. Could speed up a little in pace. Needs to be a little louder. Would like to see more on query design with data entry field. All said, thank you very much for the video. Very nicely done.

3. anonymous Tue, 10 Feb 2009 11:25

I wish you would elaborate more often on why things were done a certain way. I can remember, for example, wondering what the significance of "spin" was in the properties box while creating a form.

Great job, Thanks

Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.

Kudos and Thanks for Dai

Create a Form


¥¢¥·¥Ã¥¯¥¹ ÉÏÑ¥
70 months ago


Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.