对齐多个查询结果 [英] aligning multiple query results
问题描述
我正在尝试从2个不同的表中提取数据并循环到
检索多行。我在调整
信息方面遇到了问题。有人能引导我朝着正确的方向前进吗？我做了一些
看自己，发现了一个名为GROUP BY的东西？这就是我需要的
使用？在此先感谢。
I''m trying to pull data from 2 different tables and do a loop to
retrieve more than one row. I''m having problems with aligning the
information. Can someone lead me in the right direction? I''ve done some
looking myself and found something called GROUP BY? Is that what I need
to use? Thanks in advance.
推荐答案
kiqyou_vf写道：
kiqyou_vf wrote:
我正在尝试从2中提取数据不同的表并循环来检索多行。我在调整
信息方面遇到了问题。有人能引导我朝着正确的方向前进吗？我做了一些看待自己的东西，发现了一个名为GROUP BY的东西？这是我需要使用的吗？提前谢谢。
I''m trying to pull data from 2 different tables and do a loop to
retrieve more than one row. I''m having problems with aligning the
information. Can someone lead me in the right direction? I''ve done some
looking myself and found something called GROUP BY? Is that what I need
to use? Thanks in advance.
对不起，我今天早上的工作都没有工作。
这是不可能的在不知道你的桌子结构的情况下告诉，
你正在使用的代码和你期望的输出。
-
==================
删除x来自我的电子邮件地址
Jerry Stuckle
JDS计算机培训公司
js ******* @ attglobal.net
==================
Sorry, my mind reading isn''t working this morning.
It''s impossible to tell without knowing the structure of your tables,
the code you''re using and the output you expect.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jerry Stuckle写道：
Jerry Stuckle wrote:
kiqyou_vf写道：
kiqyou_vf wrote:
我正在尝试从2个不同的表中提取数据并循环到
检索多行。我在调整
信息方面遇到了问题。有人能引导我朝着正确的方向前进吗？我做了一些看待自己的东西，发现了一个名为GROUP BY的东西？这是我需要使用的吗？提前谢谢。
I''m trying to pull data from 2 different tables and do a loop to
retrieve more than one row. I''m having problems with aligning the
information. Can someone lead me in the right direction? I''ve done some
looking myself and found something called GROUP BY? Is that what I need
to use? Thanks in advance.
抱歉，今天早上我的阅读工作没有用。
在不知道你的结构的情况下，我们无法分辨。表格，你正在使用的代码和你期望的输出。
Sorry, my mind reading isn''t working this morning.
It''s impossible to tell without knowing the structure of your tables,
the code you''re using and the output you expect.
听起来更像UNION问题，但Jerry是对的。我们需要更多
信息来做出合理的评论。
-david-
Sounds more like a UNION problem, but Jerry is right. We need more
information to make reasonable comments.
-david-
我有一个显示多个搜索结果的页面。在每次搜索
结果时，我希望显示来自两个或多个表的唯一信息
。所有表格都有一个client_id。柱。我需要主查询
来显示基于
I have a page that displays multiple search results. On each search
result I want unique information from two or more tables to be
displayed. All tables have a "client_id" column. I need the main query
to display results based on the
这篇关于对齐多个查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
