SQL DUMP of Three tables used for LEFT JOIN query

student6

idnameclasssexhouse_id
1John DeoFourfemale2
2Max RuinThreemale1
3ArnoldThreemale1
4Krish StarFourfemale3
5John MikeFourfemale2

student_mark

mark_idstudent_idexam_dtexammark
122017-04-05Seme180
222017-04-19Seme275
312017-04-05Seme184
412017-04-19Seme276
532017-04-05Seme171
632017-04-19Sem272
712017-05-10Seme193
812017-05-24Seme290
922017-05-10Seme185
1022017-05-24Seme286
1132017-05-10Seme163
1232017-05-24Seme280
1312017-06-07Seme180
1412017-06-21Seme275
1522017-06-07Seme150
1622017-06-21Seme287
1732017-06-07Seme159
1832017-06-21Seme261
1942017-04-05Seme184
2042017-04-19Seme282
2152017-04-05Seme163
2252017-04-19Seme295
2342017-05-10Seme159
2442017-05-24Seme285
2552017-05-10Seme189
2652017-05-24Seme284
2742017-06-07Seme184
2842017-06-21Seme287
2952017-06-07Seme195
3052017-06-21Seme287

student_house

house_idh_name
1King
2Queen
3Jack

student_fee

fee_ididdtamount
112013-01-08200
212013-01-10100
322013-01-24120
432013-02-02211
522013-02-07150
632013-02-06135
742013-02-14100
Visitors Rating
Your Rating




Google+
Zubair

28-03-2018

I am new on SQL i have database which have daily customer balances to takeout potential customer i require query to retrieve data customer account #, maximum balance on which date. Please help Thanks
Zubair

28-03-2018

I am new on SQL i have database which have daily customer balances to takeout potential customer i require query to retrieve data customer account #, maximum balance on which date. Please help Thanks
Zubair

28-03-2018

I am new on SQL i have database which have daily customer balances to takeout potential customer i require query to retrieve data customer account #, maximum balance on which date. Please help Thanks

Post Comment This is for short comments only. Use the forum for more discussions.








HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us
©2000-2018 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer