I need to pull information from 4 different tables. I read taht using the "Create View" is that best way for this. Can you let me now if my code is correct?
CREATE TEMP VIEW TEBASdb.TwoYrExceptvw as SELECT tblinfoDataSheet.Issue_Price , tblinfoDataSheet.O_I_PremDisc , tblinfoDataSheet.UW_Discount , TblCashFlow.Amount , tblAllocation.AllocAmount , TblInvestInterst.IntAmt FROM tblinfoDataSheet , TblCashFlow, tblAllocation , TblInvestInterst" -- View this message in context: http://old.nabble.com/create-View-for-four-tables-tp29902765p29902765.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
