Aligning multiple query results

[kiqyou_vf]

Sorry, Google wouldn't let me post a reply. Here is the convo thus far:

Jerry Stuckle wrote:

kiqyou_vf wrote:

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.

Sounds more like a UNION problem, but Jerry is right. We need more
information to make reasonable comments.

-david-
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 $_GET['keywords'] and a second table to
display results based on the "client_id" of the main query. I don't
have any code as of yet to show you. I have done some research on UNION
and found this on mysql.com:

"Selected columns listed in corresponding positions of each SELECT
statement should have the same type. (For example, the first column
selected by the first statement should have the same type as the first
column selected by the other statements.) The column names used in the
first SELECT statement are used as the column names for the results
returned."

Is this going to be a problem since the names and information are going
to be different on each of my tables.

[Michael Austin]

kiqyou_vf wrote:

Sorry, Google wouldn't let me post a reply. Here is the convo thus far:

Jerry Stuckle wrote:

kiqyou_vf wrote:

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.

Sounds more like a UNION problem, but Jerry is right. We need more
information to make reasonable comments.

-david-
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 $_GET['keywords'] and a second table to
display results based on the "client_id" of the main query. I don't
have any code as of yet to show you. I have done some research on UNION
and found this on mysql.com:

"Selected columns listed in corresponding positions of each SELECT
statement should have the same type. (For example, the first column
selected by the first statement should have the same type as the first
column selected by the other statements.) The column names used in the
first SELECT statement are used as the column names for the results
returned."

Is this going to be a problem since the names and information are going
to be different on each of my tables.

it is a JOIN (implicit) not a UNION

select a.id,a.col2,a.col3,b.col1,b.co2,c.col1,c.col3
from table1 a, table2 b, table3 c
where b.id=a.id and c.id=a.id
and a.id = 123;


--
Michael Austin.