|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
