Home Fetch from multiple table on certain Conditions
Reply: 0

Fetch from multiple table on certain Conditions

Ankit Jaishwal
1#
Ankit Jaishwal Published in 2018-02-14 17:12:35Z

My tables are:- //To store class

Class

Class_id Class_name.
1 K.G.
2 1.
3 2.

//To store total fee types

         Fee

Fee_id Fee_name.
1 Admission.
2 Tuition.
3 Comp Lab.
4 Sci Lab.

/To store fee which is not common to each class/.

            Uncommon_Fee. 

 Uncommon_fee_id   fee_id.                     
               1              3.                           
               2              4.                            

/* To map uncommon fee with class*/.

            ClassFee_Map


   Class_id     Uncommon_fee_id.              
        1              1.                                   
        2              1.                                   
        2              2   

I have to fetch fee names according to a particular class.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.256814 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO