I know that attributes are referred to as Table.Attribute, for example, but in Base, they use "Attribute", or, if I am not mistaken, when one needs to specify the table of origin, "Table"("Attribute"). The Base tutorial I used seems to have a modified language compared to the actual HSQL language, at least based on my programmer friends reaction. If I had a prefecture named "Cebu" and a ward named "Lahug" which has a ward ID of 0, I want the query to come up with "Lahug, Cebu" on column 1, and "0" in column 2 What I want my query to produce is these two colums: "Ward Name, Prefecture Name" as a concatenation of the Ward.WardName and Prefecture.PrefectureName, and the Ward IDįor example. Table 2 is named "Ward" and has the following fields: ID, "Ward Name", and Prefecture ID which is a foreign key referencing table 1.
Table 1 is named "Prefectures" and has the following fields: ID, "Prefecture Name", and "State" I'm using LibreOffice Base Version 1:3.6.2 and it has the default HSQL engine. I'm having trouble querying a column which is supposed to be a concatenation of two fields of two separate tables. My apologies for wrong terminilogies, I am not actually a programmer, just a Base user confronted with a problem.
0 kommentar(er)
