Now, I want to learn how to write a SQL subquery. In a standard module I have lots of functions to return SQL strings to make recordsets under different circumstances. Sometimes I want to delete so...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10046197.html
Zones:
Visual BasicDate Answered: 04/06/1998 Rating: 7.6 Views: 0
i have two queries that i wish to combine together into a nested query so i can use them in an ASP project I am working on.
The two queries are as follows:
1st query (countArtist_view):
SELE...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10265044.html
Zones:
MS AccessDate Answered: 01/28/2000 Rating: 7.4 Views: 0
Hi,
Does anybody know a way of displaying the values of a joined table as a list of values eg 'A1, BZ, AZ'
main
create table #invoice (inv_id int, description varchar(30))
insert int...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20062706.html
Zones:
MS SQL ServerDate Answered: 03/31/2002 Rating: 9.0 Views: 0
I have a query that looks like this.
SELECT COUNT(Name) AS NameCount
FROM TABLENAME
WHERE Name IN
(SELECT DISTINCT Name
FROM TABLENAME
GROUP BY Name, Date)
The subquery part works fine. ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20258201.html
Zones:
MS AccessDate Answered: 01/24/2002 Rating: 6.8 Views: 0
I have the following in the SQL painter under text mode:
select unit from (
select distinct t.unit, t.ct from tag t)
And it fails. Why?
In particular, I'm trying to get the following to ...
http://www.experts-exchange.com/Programming/Editors_IDEs/PowerBuilder/Q_20261756.html
Zones:
PowerBuilderDate Answered: 08/17/2004 Rating: 7.2 Views: 0
we have an SQL statement
"update (select * from Users where IDUser = 12) set NewMSG = 1"
in MSAccess it is working just fine but when i try to run it on MSSQL Server an ERROR (Unable to parse q...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20522161.html
Zones:
MS SQL ServerDate Answered: 07/04/2004 Rating: 8.6 Views: 0
Hi, I'm trying to do a moderately complex subquery and am getting a ORA-00936 error. Can someone take a look at this and see if the syntax looks correct?
SELECT COUNT(DECODE(sq.cda,1,1,0)) As ...
http://www.experts-exchange.com/Database/Oracle/Q_20532729.html
Zones:
OracleDate Answered: 02/27/2003 Rating: 9.2 Views: 0
I have 3 tables, TA, TB and TC. TA has three columns. And I want to execute a sql query to insert rows into TA which are selected from TB and TC. My sql statement looks like:
INSERT INTO TA (SEL...
http://www.experts-exchange.com/Database/Oracle/Q_20554347.html
Zones:
OracleDate Answered: 03/18/2003 Rating: 7.4 Views: 0
Hi,
I'm trying to build some reports in MS Access from some tables. The following two tables interest me for the moment:
Dealer
DealerID PK not null
Name
.. other fields
Sale
S...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20614808.html
Zones:
MS AccessDate Answered: 05/13/2003 Rating: 7.6 Views: 0
Hi All
i need of query for the below output.
i have a table npa
-------------------
glhead acno transdate balance
===================================
1000 101 01/jan/2003 100
100...
http://www.experts-exchange.com/Database/Oracle/Q_20629878.html
Zones:
OracleDate Answered: 09/06/2004 Rating: 8.2 Views: 0
