Admin panel display top 25 registered customers with following details customer ID, Registered Date, Firstname & Last Name.
I want to display another column Which says order status. If Registered customer place successful order then order status is yes ( display order number) else display Null.
This can be achieved by joining customer table and order table, but im not that good in writing sql queries. So request some one to help me in doing this job done.
Thanks in advance