Ankita Kumari

Ankita Kumari

  • 2.1k
  • 77
  • 6k

recursive query in mysql on the basis of role

Dec 30 2021 5:20 PM

I have 2 tables user and user_activity. like

user:- iduser,f_name,type



we have to join these two tables on the basis of iduser and get the all data of user if we select type=1 then get all the data of type=2, if we select type=2 then get all data of type 3 etc...


Answers (1)