且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

比较同一表中多个列/行中的数据与查询

更新时间:2022-12-12 16:04:26

为什么不命名这个列,并像这样引用它们我有一群人列出他们有什么在一栏和下一栏中,他们列出了他们想要的东西。?


当你有一张桌子时( ''Table1'')包含以下字段:
Why not name this columns, and refer to them like this "I have a bunch of people that have listed what they have in one column and in the next column, they list what they want."?

when you have a table (''Table1'') with these fields:
展开 | 选择 | Wrap | 行号


我不认为这就那么简单。

当菲尔还有一个橙子但想要一个苹果时会发生什么?所以Sally& Phil匹配Johnny。


另外,请尽量避免使用对象名称(表格,查询,表格和报告)以及字段名称中的空格。此外,ID作为字段名称不会告诉您该字段 - RequestID可能更好。此外,如果你想避免作家的抽筋,保持名称简短但有意义。 拥有有什么问题?和请求?


Phil
I don''t think it''s as simple as that.
What happens when Phil also has an orange but wants an apple? So both Sally & Phil match Johnny.

As an aside, try to avoid spaces in Object Names (Tables, Queries, Forms & Reports) and also in field names. Also ID as a field name tells you nothing about the field - RequestID might be better. Also, if you want avoid writers'' cramp, keep names short but meaningful. What is wrong with "Owned" and "Requested"?

Phil


@PhilWalton:你是对的,这只是得到 j1s15n 开始了,现在让我们等待 j1s15n
@PhilWalton: you are right, this was just a quick answer to get j1s15n started, now let''s wait for j1s15n