Hi, --- On Fri, Jun 21, 2013 at 3:46 PM, Abdur Rahman <[email protected]> wrote: | and the payment table is as follows | ======================================== | | Id | Year | member_Id | | ======================================== | | 01 | 1947 | 02 | | | 02 | 1958 | 03 | | | 03 | 2000 | 03 | | | 04 | 1988 | 04 | \--
Instead of duplicating the year entries in the above, you can create a separate table for Year with "Id", and "Year", and use Year_Id in the above. SK -- Shakthi Kannan http://www.shakthimaan.com _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
