On Mon September 11 2006 17:36, + ajay bonde wrote: > I am new user of base application. Previously i was using MS Access as data > base. In that totalling or multiplication of columns etc was done by > writing SQL from the ready made window provided by MS Access. I am using > Openoffice.base on Linux platform. I have no knowledge of writing SQL > query. Please guide me whether openoffice.base has any readymade window for > writing SQL? Please guide me the name of book and publisher in India which > deale with openofffice.base only. or whether online help is available on > any site. with regards from
As you are not subscribed you may not have seen that: On Tue September 26 2006 05:43, + Matt Needles wrote: > You can create queries in one of three modes: using the designer, using > the wizard, or via SQL > You may modify queries using the designer or in SQL mode > Once in the Designer or the SQL mode, you may switch back and forth > between these modes at will. If you wish, you can create a simple query > with the designer or wizard, then add calculated fields by opening the > query in SQL mode. It will show you something like this: > > SELECT "field-name", "field-name", "field-name" FROM "table-name" > "table-alias"; > > Each field-name may optionally be followed by AS "alias-name". > This leads to how to do calculated columns. Suppose you have a table > named Stock with columns named SKU, Desc, QtyOnHand, and Price. You can > calculate the value of the quantity on hand by making your SELECT > statement read as follows: > > SELECT "SKU", "ItemDesc", "QtyOnHand", "Price", "QtyOnHand" * "Price" AS > "ValueOnHand" FROM "Stock" "Stock"; > > You can get as complex as you need be in your calculated columns, even > using constants and parentheses and built-in functions, like ROUND(), > INT(), and so on. > > You may also add a clause to the statement to order it by any particular > column, e.g., > > SELECT "SKU", "ItemDesc", "QtyOnHand", "Price", "QtyOnHand" * "Price" AS > "ValueOnHand" FROM "Stock" "Stock" ORDER BY "ValueOnHand" DESC; > > You can do the same type of thing on reports, BTW. Please reply to [email protected] only. -- 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]
