|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
table join |
|
From: |
Stephen Yenchik |
|
Date: |
1/17/2002 12:33:46 PM |
|
IP: |
207.106.130.114 |
Hi. I'm trying to write a query that joins fields from two tables. The syntax is eluding me because I need to join two seperate counts from the same table with all of the fields from another table.
The first table is called actionsMB, and I need a count where coid=variable and another where coid=variable and actiontype='Spoke With Decision Maker'
this must be joined with select * from company_local
Any help on the syntax of such a query would be greatly appreciated. Thanks.
Stephen |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
