Hi all, I need a help regarding creating a query in Libre Office Base.
Suppose I have two tables A and B each having few columns (identical in headings). Both the tables are linked by a common primary key (ID No). Table A is completely filled while Table B has only few data filled. (though all records are equal) Now, I wish to write a query that could do the following: * If Value B is not blank (or less than 1), Take Value B * If Value B is blank, Take Value A * Input the result into another table/ query. For instance, Table A Table B ID Value ID Value 1 50 1 60 2 30 2 3 40 3 40 4 35 4 5 25 5 20 Result: Query C (or Table D) ID Value 1 60 2 30 3 40 4 35 5 20 Is there any way to do that?? (If the solution is in design mode, I would be very happy. But, even SQL solutions are welcome!!) P.S: I have earlier worked with MS Access Databases (Only Design/ Wizard Mode). I am entirely new to Libre Office Base. -- Regards, ARUN P A Tailor’s mistake is a Fashion But, An Engineer’s mistake is a Disaster. "Preserve the earth; Else we will perish" _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
