asp_databases thread: Inner Joins
Message #1 by "Ken DeFilipps" <kdefilip@m...> on Fri, 22 Feb 2002 20:44:03
|
|
Hi.
I need some assistance with an inner join. The best I can do is:
Parent1 child1
Parent1 Child2
Parent1 Child3
Paretn2 child1
Parent2 Child2
Etc, etc
There has be be a way to do this, but I can't figure it out. Does anyone
have any code I could pick apart or a resource?? Thanks.
My select statement follows:
ObjCommand.CommandText = "SELECT proiss.ID, proiss.issue,proiss.respons,
proiss.priority," & _
"proiss.todo,proiss.status,proiss.resolution, proiss.date_entered,
jobdetail.control,jobdetail.act_detail,jobdetail.created_by,jobdetail.enter
ed " & _
"FROM proj_issues AS proiss " & _
"INNER JOIN job_detail AS jobdetail " & _
"ON (proiss.id = jobdetail.control) " & _
"WHERE proiss.id ='" & strID & "'" & _
"GROUP BY proiss.resolution,proiss.ID,proiss.issue,proiss.respons,
proiss.priority,proiss.todo,proiss.status,proiss.resolution,
proiss.date_entered, jobdetail.control, jobdetail.created_by,
jobdetail.act_detail, jobdetail.entered " & _
"ORDER BY proiss.id, jobdetail.entered"
Thanks again for any help.
Please respond to mailto:ken_def@y...?subject=ASP_HELP
Message #2 by "Mitch Swetsky" <mswetsky@r...> on Sat, 23 Feb 2002 21:10:05 -0500
|
|
I have one in a script
My SQL has the following Join Statement
After the select portion
FROM TH6040 LEFT JOIN TH6042 ON TH6040.LOG_ID = TH6042.CALL_ID
Hope this can help
----- Original Message -----
From: Ken DeFilipps <kdefilip@m...>
To: ASP Databases <asp_databases@p...>
Sent: Friday, February 22, 2002 8:44 PM
Subject: [asp_databases] Inner Joins
> Hi.
> I need some assistance with an inner join. The best I can do is:
>
> Parent1 child1
> Parent1 Child2
> Parent1 Child3
> Paretn2 child1
> Parent2 Child2
> Etc, etc
>
> There has be be a way to do this, but I can't figure it out. Does anyone
> have any code I could pick apart or a resource?? Thanks.
>
> My select statement follows:
>
> ObjCommand.CommandText = "SELECT proiss.ID, proiss.issue,proiss.respons,
> proiss.priority," & _
> "proiss.todo,proiss.status,proiss.resolution, proiss.date_entered,
>
jobdetail.control,jobdetail.act_detail,jobdetail.created_by,jobdetail.enter
> ed " & _
> "FROM proj_issues AS proiss " & _
> "INNER JOIN job_detail AS jobdetail " & _
> "ON (proiss.id = jobdetail.control) " & _
> "WHERE proiss.id ='" & strID & "'" & _
> "GROUP BY proiss.resolution,proiss.ID,proiss.issue,proiss.respons,
> proiss.priority,proiss.todo,proiss.status,proiss.resolution,
> proiss.date_entered, jobdetail.control, jobdetail.created_by,
> jobdetail.act_detail, jobdetail.entered " & _
> "ORDER BY proiss.id, jobdetail.entered"
>
> Thanks again for any help.
> Please respond to mailto:ken_def@y...?subject=ASP_HELP
$subst('Email.Unsub').
>
|
View Cart
