问题描述
我有一个提供商表，其中包含许可证号和全名字段等。如果我有新的条目，如果昵称表中存在昵称，Deman帮助我能够输入昵称并将其更改为全名。我还有一个名为TA的表，我在其中输入请求，使用许可证号链接到providers表。 （fullname字段仅存在于providers表中。）我希望能够通过输入昵称（因为它存在于昵称表中）而不是输入fullname来查询TA表中的请求。有人可以帮忙吗？在此先感谢。
I have a table of providers that has a license number and fullname field, among others. Deman helped me with being able to enter a nickname and having it change to the fullname if a nickname exists in a nickname table when I have new entries. I also have a table called TA where I enter requests, linking to the providers table with the license number. (The fullname field exists only in the providers table.) I''d like to be able to query the TA table for requests by entering the nickname (as it exists in the nickname table) rather than entering the fullname. Can anyone help? Thanks in advance.
推荐答案
这篇关于查询数据时将昵称转换为全名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！