28, 2004 10:20 PM
To: bruce; [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
Hello bruce,
Wednesday, September 29, 2004, 6:57:34 AM, you wrote:
b hi
b i'd like to be able to merge/combine the two tables so that i get
b
If you post your two original SQL statements (the ones you use to build
your example tables) I think I can help you to merge your results,
possibly without the need for temporary tables. Also, what version of
MySQL are you using?
Shawn Green
Database Administrator
Unimin Corporation - Spruce
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 29, 2004 6:42 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
If you post your two original SQL statements (the ones you use to build
your example tables) I think I can
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 10:20 PM
To: bruce; [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
Hello bruce,
Wednesday, September 29, 2004, 6:57:34 AM, you wrote:
b hi
b i'd like to be able to merge/combine the two tables so that i get
]
Subject: Re: merging of two tables using temp tables???
Bruce,
My first thought was the LEFT JOIN Jacques suggested. My second thought was
that it would be better to just create a single query that gets what you
want in the first place. So I looked a little closer, and now I'm confused
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: merging of two tables using temp tables???
If you post your two original SQL statements (the ones you use to
build
your example tables) I think I can help you to merge your results,
possibly
without the need for temporary tables. Also, what
bruce wrote:
thanks for the reply...
and my bad on the diff between the sql. the actual sql had ~100 values. (i
simply cut it to demonstrate what i'm trying to do!!)
i took the two tables created by the initial sql statements and modified
them so that they both had the same structure. i then
Hello bruce,
Wednesday, September 29, 2004, 6:57:34 AM, you wrote:
b hi
b i'd like to be able to merge/combine the two tables so that i get
b +--+--++--+---+-+
b | ID | type | status | user | ID| uID |
b +--+--++--+---+-+
b