|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
