SELECT HeaderCode, PolicyRefCode, ScopeofCover, CoverExtension, CoverExclusion, SubjectMatter, Remark, -1 CompanyOrder, Excess, 0 LTADiscount FROM Underwriting_Policy_Schedule_Header The SQL query i have tried is pasted below: SELECT * FROM ( What I wanted to achieve is shown below: Section SerialNo Description Premiumġ On main hotel building of 32 bedrooms including but not limited to all 50,000.00Ģ On complete boundary walls, gates and fences including electric fence 5,000.00ġ On electronic equipments of all Elect. I have two tables ( Underwriting_Policy_Schedule_Header) which stored the category headers while the second Table ( Underwriting_Policy_Schedule) stored the header body. Please I need your assistance on using Categorized subquery in SQL.
0 Comments
Leave a Reply. |