Re: Combining two row into one

Thanks for the reply. Upon further reflection I guess I knew that, although
I would think it could become rather awkward if there are variable numbers
of records with the same date from either table.

"John Spencer" <spencer@xxxxxxxxx> wrote in message
news:OQzN27$JGHA.2696@xxxxxxxxxxxxxxxxxxxxxxx
Yes, you can show records from the same table joined to itself. Just like
you can join table a to table b and get all fields from the two tables in
one record.

"BruceM" <bamoob@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23mCXqi$JGHA.3504@xxxxxxxxxxxxxxxxxxxxxxx
Are you saying records from two tables that share a criterium such as
date can be combined into a single query record? If so, I misspoke in my
attempt to reply.

"John Spencer" <spencer@xxxxxxxxx> wrote in message
news:OgigIa$JGHA.3100@xxxxxxxxxxxxxxxxxxxxxxx
Your request was hard to figure out, but I think I have a start for a
solution.

SELECT DISTINCT A.*, B.*
FROM TheTable As A Inner Join the Table as B
ON A.Date = B.Date

If you have a primary key in the table then you will get multiple rows
in the match. So you will have to remove the primary key from the
SELECT clause by specifying the fields you want.

"Rajat" <Rajat.22jzy0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Rajat.22jzy0@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

hi,

iam trying to make a query which will return 1 row with n+n columns
from 2 rows(same table) with n columns each.

the initial table structure would be like this-

Code:
--------------------
date | 12 am | 1 am | 2am | ....... | 11 pm
--------------------


& finally the table should be like

Code:
--------------------
date | 12 am | 1 am | 2am | ....... | 11 pm | x12am | x1 am | x2am |
....... | x11 pm
--------------------


so basically combining two rows from 1st table to 1 row (in new
table/or otherwise)...
i am using VB to execute this query.....so i can construct the query in
VB & then execute it....

-edit:-
actually dont care by column names in 2nd table


sub topic:
the main problem is that....sometimes i need few columns from 1 row and
few from another......
for eg -
on 2/1/2006 - need columns 21pm | 22pm | 23pm <- this is 1 row
while on 2/2/2006 - need columns 12 am | 1 am | 2am | 3am | 4am | 5am
<- 2nd row
i need to combine both these rows & display 1 row with only those
columns....

Trust iam clear. :confused:

TIA


--
Rajat
------------------------------------------------------------------------
Rajat's Profile: http://www.hightechtalks.com/m876
View this thread: http://www.hightechtalks.com/t2349003









.

Relevant Pages

  • Re: Combining two row into one
    ... So you will have to remove the primary key from the SELECT ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • Re: Combining two row into one
    ... So you will have to remove the primary key from the SELECT ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
  • What is Indexing in mysql and how it will be useful and how we can retrieve database content easily
    ... Now I am storing data using one primary key and I am just using ... taking long to execute the query. ... some indexing or cluster indexing which might help me but I am not so ...
    (comp.lang.php)
  • Re: Import Automation and...
    ... If there's no existing table, construct and execute a create-table ... query (this is different from a make-table query, ... F2 CHAR CONSTRAINT PrKey PRIMARY KEY, ... construct and execute an append query instead of a make-table query. ...
    (microsoft.public.access.externaldata)
  • Re: Combining two row into one
    ... can be combined into a single query record? ... iam trying to make a query which will return 1 row with n+n columns ... VB & then execute it.... ... Trust iam clear. ...
    (microsoft.public.access.queries)
Quantcast