| Author |
TSQL Join question
|
|
| Jonh Smith 2005-04-22, 11:23 am |
| Hello, folks
Desc. two tables table A
CriteriaID
1
2
3
Table B
UID ResultID CriteriaID
1 1 1
2 1 2
3 1 3
4 2 1
Want to build a query which gonna show me group by ResultID only records
from table B where B.CriteriaID = {1,2,3} from table A
| |
| Aaron [SQL Server MVP] 2005-04-22, 11:23 am |
| Are you looking to concatenate?
If so: http://www.aspfaq.com/2529
If not: please give better specs (see sig)
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Jonh Smith" <support@rtsplus.com> wrote in message
news:Ov5sBo0RFHA.580@TK2MSFTNGP15.phx.gbl...
> Hello, folks
> Desc. two tables table A
>
> CriteriaID
> 1
> 2
> 3
>
> Table B
>
> UID ResultID CriteriaID
> 1 1 1
> 2 1 2
> 3 1 3
> 4 2 1
>
> Want to build a query which gonna show me group by ResultID only records
> from table B where B.CriteriaID = {1,2,3} from table A
>
>
>
| |
| Jonh Smith 2005-04-22, 11:23 am |
| Thank you for your response, i'm looking answer for my question , please do
not asume what i'm looking for.
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:O$a9qq0RFHA.904@tk2msftngp13.phx.gbl...
> Are you looking to concatenate?
> If so: http://www.aspfaq.com/2529
> If not: please give better specs (see sig)
>
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
>
>
> "Jonh Smith" <support@rtsplus.com> wrote in message
> news:Ov5sBo0RFHA.580@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Michael C# 2005-04-22, 11:23 am |
| He's not assuming. Hence the question mark at the end. Are you looking for
INNER JOIN syntax? If so, it's in BOL.
No assumption here either, just asking a simple question based on the info
you provided. Your "group by" question is probably the main ??? here, but
without your expected results it's hard to tell exactly what you want (hence
Aaron's question about concatenation).
If you could kindly post your DDL and expected result as Aaron asked
(http://www.aspfaq.com/5006). It would be much easier to give you a more
complete answer.
"Jonh Smith" <support@rtsplus.com> wrote in message
news:%232Xy6w0RFHA.2604@TK2MSFTNGP10.phx.gbl...
> Thank you for your response, i'm looking answer for my question , please
> do not asume what i'm looking for.
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:O$a9qq0RFHA.904@tk2msftngp13.phx.gbl...
>
>
| |
| Jonh Smith 2005-04-22, 11:23 am |
| Hello 'Michael C#'
Thank you for your response, IF you do not understand my question with Aaron
please leave this question for who may understand this.
Thank you so much for your help !!!
"Michael C#" <howsa@boutdat.com> wrote in message
news:uKixs20RFHA.1396@TK2MSFTNGP10.phx.gbl...
> He's not assuming. Hence the question mark at the end. Are you looking
> for INNER JOIN syntax? If so, it's in BOL.
>
> No assumption here either, just asking a simple question based on the info
> you provided. Your "group by" question is probably the main ??? here, but
> without your expected results it's hard to tell exactly what you want
> (hence Aaron's question about concatenation).
>
> If you could kindly post your DDL and expected result as Aaron asked
> (http://www.aspfaq.com/5006). It would be much easier to give you a more
> complete answer.
>
> "Jonh Smith" <support@rtsplus.com> wrote in message
> news:%232Xy6w0RFHA.2604@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Michael C# 2005-04-22, 11:23 am |
| You got it Wal-Mart boy.
"Jonh Smith" <support@rtsplus.com> wrote in message
news:%234NSF80RFHA.1172@TK2MSFTNGP12.phx.gbl...
> Hello 'Michael C#'
> Thank you for your response, IF you do not understand my question with
> Aaron please leave this question for who may understand this.
> Thank you so much for your help !!!
>
>
>
> "Michael C#" <howsa@boutdat.com> wrote in message
> news:uKixs20RFHA.1396@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Jonh Smith 2005-04-22, 11:23 am |
| This is a rude, Michael C MINUS !
how do you can put in your name C# this is imposible for your mentalaty
"Michael C#" <howsa@boutdat.com> wrote in message
news:OwiEl%230RFHA.996@TK2MSFTNGP09.phx.gbl...
> You got it Wal-Mart boy.
>
> "Jonh Smith" <support@rtsplus.com> wrote in message
> news:%234NSF80RFHA.1172@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Aaron [SQL Server MVP] 2005-04-22, 11:23 am |
| Good luck with your problem. If your "mentalaty" can't handle the questions
I asked, I have no doubt that this is going to take you weeks to solve.
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Jonh Smith" <support@rtsplus.com> wrote in message
news:OHQKYC1RFHA.3880@tk2msftngp13.phx.gbl...
> This is a rude, Michael C MINUS !
>
> how do you can put in your name C# this is imposible for your mentalaty
>
>
>
>
>
>
> "Michael C#" <howsa@boutdat.com> wrote in message
> news:OwiEl%230RFHA.996@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Jonh Smith 2005-04-22, 11:23 am |
| Thank you Aaron for good luck, I solved problem.
Solution in sqlserver.programming
Good luck to you !
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OHTpkV1RFHA.3972@TK2MSFTNGP14.phx.gbl...
> Good luck with your problem. If your "mentalaty" can't handle the
> questions I asked, I have no doubt that this is going to take you weeks to
> solve.
>
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
>
> "Jonh Smith" <support@rtsplus.com> wrote in message
> news:OHQKYC1RFHA.3880@tk2msftngp13.phx.gbl...
>
>
| |
| Aaron [SQL Server MVP] 2005-04-22, 11:23 am |
| > Thank you Aaron for good luck, I solved problem.
Only because Alejandro is more patient than most of us, and quite possibly
psychic, too.
You should read through http://www.aspfaq.com/5006 so you might grasp why
people ask you for more information than scribbled narrative. It might even
become clear why verbally abusing such people is asinine and
counter-productive.
However, on both counts, I'm not going to hold my breath. And next time you
ask a question, I'm certainly going to ignore it.
| |
| Alejandro Mesa 2005-04-22, 11:23 am |
| Shame I answered his question in the SQL Server Programming ng, I should not
do it, but I did not know about this thread.
AMB
"Aaron [SQL Server MVP]" wrote:
> Good luck with your problem. If your "mentalaty" can't handle the questions
> I asked, I have no doubt that this is going to take you weeks to solve.
>
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
>
> "Jonh Smith" <support@rtsplus.com> wrote in message
> news:OHQKYC1RFHA.3880@tk2msftngp13.phx.gbl...
>
>
>
| |
| Jonh Smith 2005-04-22, 1:23 pm |
| > Only because Alejandro is more patient than most of us, and quite possibly
Alejandro did't ask me extra questions, he just got my point.
Aaron you just looking excuse! Enough for now just stop posting.
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uCqQ7i1RFHA.3880@tk2msftngp13.phx.gbl...
>
> Only because Alejandro is more patient than most of us, and quite possibly
> psychic, too.
>
> You should read through http://www.aspfaq.com/5006 so you might grasp why
> people ask you for more information than scribbled narrative. It might
> even become clear why verbally abusing such people is asinine and
> counter-productive.
>
> However, on both counts, I'm not going to hold my breath. And next time
> you ask a question, I'm certainly going to ignore it.
>
| |
| Quentin Ran 2005-04-22, 1:23 pm |
| Aaron,
you really don't deserve this. You need to sharpen your psychics with
Alejandro to be able to tell whether you are dealing with a piece of junk,
and if so, what kind of junk you are dealing with.
Quentin
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uCqQ7i1RFHA.3880@tk2msftngp13.phx.gbl...
>
> Only because Alejandro is more patient than most of us, and quite possibly
> psychic, too.
>
> You should read through http://www.aspfaq.com/5006 so you might grasp why
> people ask you for more information than scribbled narrative. It might
> even become clear why verbally abusing such people is asinine and
> counter-productive.
>
> However, on both counts, I'm not going to hold my breath. And next time
> you ask a question, I'm certainly going to ignore it.
>
| |
| Aaron [SQL Server MVP] 2005-04-22, 1:23 pm |
| > Alejandro did't ask me extra questions, he just got my point.
No, he guessed. You're really demonstrating your comprehension skills now.
> Enough for now just stop posting.
Oh absolutely, yes sir, I'm sure the whole group shares your view too.
| |
| Michael C# 2005-04-22, 1:23 pm |
| This OP sounds insanely (key word being "insane") like TargetBleigh of
Wal-Mart/Car Wash fame...
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:Oo6P0A2RFHA.1096@tk2msftngp13.phx.gbl...
>
> No, he guessed. You're really demonstrating your comprehension skills
> now.
>
>
> Oh absolutely, yes sir, I'm sure the whole group shares your view too.
>
| |
| Aaron [SQL Server MVP] 2005-04-22, 1:23 pm |
| > This OP sounds insanely (key word being "insane") like TargetBleigh of
> Wal-Mart/Car Wash fame...
I thought the same, even before the reference you made earlier in the
thread.
Ah well. The worst that happens is he gets fired for his bumbling
incompetence, and one of us is hired to go clean up the mess he leaves
behind. :-)
| |
| Jonh Smith 2005-04-22, 1:23 pm |
| Aaron SQL Server dummy, Michael C Minus
get back for your bumbling work, stop spaming for whole group.
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uFKWyK2RFHA.1172@TK2MSFTNGP12.phx.gbl...
>
> I thought the same, even before the reference you made earlier in the
> thread.
>
> Ah well. The worst that happens is he gets fired for his bumbling
> incompetence, and one of us is hired to go clean up the mess he leaves
> behind. :-)
>
| |
| Michael C# 2005-04-22, 8:23 pm |
| You're still here Mr. "I-don't-even-know-how-to-spell-'J-O-H-N'" Smith? I
spit in your general direction TargetBleigh II.
"Jonh Smith" <snapplefor@hotmail.com> wrote in message
news:uw9hRn2RFHA.3052@TK2MSFTNGP09.phx.gbl...
> Aaron SQL Server dummy, Michael C Minus
> get back for your bumbling work, stop spaming for whole group.
>
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:uFKWyK2RFHA.1172@TK2MSFTNGP12.phx.gbl...
>
>
| |
| Jonh Smith 2005-04-22, 8:23 pm |
| Good for you Michael C Minus.
"Michael C#" <howsa@boutdat.com> wrote in message
news:OYz8wt2RFHA.244@TK2MSFTNGP12.phx.gbl...
> You're still here Mr. "I-don't-even-know-how-to-spell-'J-O-H-N'" Smith? I
> spit in your general direction TargetBleigh II.
>
> "Jonh Smith" <snapplefor@hotmail.com> wrote in message
> news:uw9hRn2RFHA.3052@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Aaron [SQL Server MVP] 2005-04-22, 8:23 pm |
| > Good for you Michael C Minus.
Are you done, or should we report you to the teacher? Maybe she'll make you
miss recess.
*plonk*
| |
| Jonh Smith 2005-04-22, 8:23 pm |
| Good for you too Aaron SQL Server Dummy
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:edBDs72RFHA.3944@TK2MSFTNGP10.phx.gbl...
>
> Are you done, or should we report you to the teacher? Maybe she'll make
> you miss recess.
>
> *plonk*
>
| |
|
| "Jonh",
Your arrogance is not going to get you anywhere. What you actually deserve
is not an answer to your questions but a good
Spank.
Gopi
"Jonh Smith" <snapplefor@hotmail.com> wrote in message
news:%23WhS%23$2RFHA
.3496@TK2MSFTNGP12.phx.gbl...
> Good for you too Aaron SQL Server Dummy
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:edBDs72RFHA.3944@TK2MSFTNGP10.phx.gbl...
>
>
| |
| Mike Epprecht \(SQL MVP\) 2005-04-23, 8:23 pm |
| I never knew that RTS plus would allow an employee of theirs to give their
company such a bad name. Bad on you John.
From: "Jonh Smith" <support@rtsplus.com>
Hiding later under a Hotmail account does not help......
I would hate so see John explaining to a paying customer why something does
not work.......
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
"gopi" <rgopinath@hotmail.com> wrote in message
news:Oe0brWESFHA.2860@TK2MSFTNGP10.phx.gbl...
> "Jonh",
>
> Your arrogance is not going to get you anywhere. What you actually deserve
> is not an answer to your questions but a good
> Spank.
>
> Gopi
>
> "Jonh Smith" <snapplefor@hotmail.com> wrote in message
> news:%23WhS%23$2RFHA
.3496@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|