posted 14 years ago
Hi
Im trying to retrieve two different values from the same field for a single record using a query. My query is something like this
In the above query, Im trying to get the user, instructor id and instructor name from the user table. But Im not able to retrieve the correct results. I have also tried creating an alias name for the user table but still not able to get the complete list. Im getting duplicate records as well. please Advise
Regards,
Varshini