Back when I was working, over 10 years ago (since retired), part of my job included working with databases so I’m fairly familiar with working with Views, but it was at the SQL level and I’m an OOo Base newbie – so I’m kinda spinning my wheels here.
What I’ve got is two tables I created and I want to join them together (a 1:n relationship) to create a ‘third’ table I can run Queries and Reports against.
If I remember right, the SQL syntax would be something like:
CREATE VIEW “View_1” AS
SELECT
TBL1.FLD_A AS FLDA,
TBL1.FLD_B AS FLDB,
TBL1.FLD_C AS FLDC,
COUNT(*) AS CNT,
MAX(TBL2.FLD_A) AS MY_MAX_DT
FROM TBL1
LEFT OUTER JOIN TBL2 ON
FLD_B = TBL1.FLD_B
WHERE TBL1.FLD_A > ‘ ‘
ORDER BY TBL1.FLD_A
I can’t figure out how to go about doing this. The tutorial I’m going through doesn’t talk about working with Views very much, and I’ve pretty much hit a brick wall when rooting around after clicking ‘Create View… ‘ on the main menu.
Can anyone nudge me in the right direction or point to some reference material or maybe even a Users Guide for OOo Base?
Thanks!