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-05Sem180
222017-04-19Sem275
312017-04-05Sem184
412017-04-19Sem276
532017-04-05Sem171
632017-04-19Sem272
712017-05-10Sem193
812017-05-24Sem290
922017-05-10Sem185
1022017-05-24Sem286
1132017-05-10Sem163
1232017-05-24Sem280
1312017-06-07Sem180
1412017-06-21Sem275
1522017-06-07Sem150
1622017-06-21Sem287
1732017-06-07Sem159
1832017-06-21Sem261
1942017-04-05Sem184
2042017-04-19Sem282
2152017-04-05Sem163
2252017-04-19Sem295
2342017-05-10Sem159
2442017-05-24Sem285
2552017-05-10Sem189
2652017-05-24Sem284
2742017-06-07Sem184
2842017-06-21Sem287
2952017-06-07Sem195
3052017-06-21Sem287

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


plus2net.com



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 your comments , suggestion , error , requirements etc here .










We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer