I have stored the some products and there respective category in sql. enter image description here

Like this. Now I want fetch all product from table with respective category. output should be=> enter image description here

  • $\begingroup$ Please edit the question to explain, precisely, how the output is obtained from the input. $\endgroup$ – Michael Green Dec 14 '20 at 11:59
  • $\begingroup$ name is the set of all distinct products and categories, and flag_for_ca is a bit field (Y/N) if the name is a category?? $\endgroup$ – Sam cd Feb 19 at 15:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.