Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Performance Issue using left or substring function in Sql Server2005Express
- Hi, I've tried the following query in SQL SERVER 2005, SQL Express 2005 and MACCESS. select * from Table1 where drid in (SELECT DrID FROM Table2 WHERE (substring(PostalCode,1,3) IN ('B0E','B1P','B2H','B2Y','B3A','B3M','B4A','B4H','E1A','E1C','E1N','G0A', …)) and (substring(Telephone,1,3) IN ('204','250','306','403','416','418','450','506','514','519','604','613','705','780','807','819','902','905'))) The query is using two table. The first one...
- Tags: Databases, desbiens_mathieu@..., performance, MACCESS, Table1, Microsoft SQL Server, Table2, execution time, SQL, Microsoft SQL Server 2005
- Discussion threads 2007-10-22
- Join a query with one of the Tables used to generate the query
- Hi to everybody,I would like to know if it's possible to do this in MSAccess SQL:Select * FROM (table1 LEFT JOIN table2 ON table1.field1 = table2.field1) LEFT JOIN table2 ON table1.field2 = table2.field1Note that table2 is being used twic
- Tags: join, sql, programming, access, software, microsoft, windows, Table2, LEFT JOIN, rayasta@..., Table1, Table1.field1
- Discussion threads 2006-12-13
Additional Resources
- Raffle Tickets
- I want to have it so that if some one pledges £5 on one table. At the click of a button another table is updated with 5 tickets allocated to this person.check out how this is done with the indispensible northwind.mdb sample database free for download from microsoft. the really...
- Tags: simonevans31@...
- Q&A 2005-01-26
- Trouble Querying Database
- I have a table with a list of issues includes duplicates associated with a file name. There is a separate query that's linked to this table by file name and includes about 10 calculated fields associated with the file name no duplicates. I would like to create a query that...
- Tags: CR2
- Discussion threads 2006-08-16
- Nested Select statements
- Has anyone ever used a statement like this:Select column1, column 2, (select columnA from table2) from table1 where....?This is contrary to anything I have ever seen in SQL (especially ANSI/ISO SQL), and I would appreciate your comments. ThanksSKNo I haven't, not once in in 17 yearsmore to the point...
- Tags: Databases, shelley.kuebler@...
- Discussion threads 2007-11-19
- SQL code in vb join > 3 tables
- how do i code in vb6 joining 3 or more tables in. it would be ver helpful oif you can help. thank you..SELECT whateverFROM (table1 LEFT JOIN table2 ON table1.key=table2.key)LEFT JOIN table3 ON table1.key=table3.key;
- Tags: LEFT JOIN
- Q&A 2005-07-18
- Access query to combine table fields
- How do I construct an Access query to combine table fieldsOpen the query in design viewIn the Lower section, in the Field of teh column where you want to display the joined fields type the formulaExampleFieldname:[First Name] & [Last Name]orFieldname:[First Name]&" " & [Last Name] (if you need space between...
- Tags: acampbell@..., First Name, Last Name, Microsoft Access, software
- Q&A 2004-10-06
- multi-table with alias
- I've got a database with numerous tables. I want to do a query that is like:Select projnum, projtitle, projmgr, projclerk fromProjects inner join people where people.peoplecnt=projects.projmgrI get that part to work. Now the projmgr and all other people assoc with the project are in the people table...
- Tags: SELECT
- Discussion threads 2005-03-23
- Sql Select from Databases on Multiple MSSql Servers
- Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...
- Tags: Programming languages, Databases, awcrichton@..., SQL, database
- Discussion threads 2007-05-16
- SQL basics: Query multiple tables
- Whether you're learning SQL for the first time or just need a refresher, read this article to learn when to use SELECT, JOIN, subselects, and UNION to access multiple tables with a single statement.It’s sometimes difficult to know which SQL syntax to use when combining data that spans multiple tables....
- Tags: Programming languages, Databases, Shelley Doll, multiple table, SQL, database
- Technical articles 2002-08-12
- SQL Join
- HiI have 2 tables that I want to join, the two fields I wish to join on are both the same data type "VARCHAR2(20)" however field one contains data in the format "99999999" while field two contains data in the format "99999999/9". There is a unique match on characters 1-8...
- Tags: graemeduncan@..., inner join, join, software, SQL
- Q&A 2005-02-08
- create select query with diff. mdb files
- i created two ms access database to hold my data.how can i create a select query that will include the table from the other database?can someone please help me..............?any strategies/techniques/ideas will sure be of help.thanks.You need two Queries. One with Select command for one table, other with select command for...
- Tags: Storage, Databases, database
- Q&A 2006-01-06
- Access - filter for dates not present & w/o records
- I maintain records with a sub table of dated entries. Want to select records which have no entries for a given time period. Example - all records with no activity in December. I need all records without dates >11/30/2004 and 11/30/2004 and 11/30/2004 and 11/30/2004 and
- Tags: Microsoft Access, PO Number, PO Status, qaqcdave@..., software
- Q&A 2004-12-22
- Another crash course in SQL
- Does knowing how to query a table from an SQL command line come in handy in your IT shop? In this crash course in SQL, learn how to query two or more tables at once.In July 2001's "A crash course in SQL," I explained how to query a database using...
- Tags: Programming languages, Databases, Donations, Jeff Davis, SQL
- Technical articles 2001-12-04
- SQL JOINs make it easy to find and fix missing data
- Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.In response to previous SQL lessons, TechRepublic members including Michael M. and Jason P. have posted comments requesting a basic explanation of the types of JOINs...
- Tags: Programming languages, Databases, Figure B, Jeff Davis, SQL, DonorID 2
- Technical articles 2002-04-30
- How do I copy an Access table with VB?
- I need to be able to copy the structure of an existing Access table in VB, checking to see if a couple of columns exist, if not, creating them, and saving them with a new name. Is this possible programatically?ADOXYes it is possible. Check out ADOX and ADO.Here is an...
- Tags: Access Table, Microsoft Access, Microsoft Visual Basic, ADOX, table copy, access, vb, TechRepublic@..., networking, PSchluter@...
- Discussion threads 2006-07-28
- Data Extraction Software
- Data Extraction / Merging Software I am looking for a Excel plug-in or some windows based application that can extract data from many CSV files then, clean, manipulate, and merge data based on easy to define maps, scripts or macros. One of my goals is to find a software tool...
- Tags: Data, Data Extraction, ABC123 Metal, Microsoft Access, Microsoft Excel, Column, daniel@..., software, Column B, Column C
- Q&A 2006-06-06
- database/files
- what is differnce between file structure and database structure?how they stored in the hard disk?Here is the basic definitions of file/database structures as they pertain to databases. How this helps!A database consists of a number of related files.A file sometimes called a table consists of a number of related...
- Tags: Storage, Databases, database
- Q&A 2005-01-19
- Build Your Skills: The underpinnings of SQL joins
- The cornerstone of the relational database system is the relationship—the association between tables that allows you to combine data from different but related sources. Most of the time, these associations are intuitive and work just as you expect. However, problems can arise when the wrong join is applied to a...
- Tags: Programming languages, Databases, join, clause, SQL
- Technical articles 2004-01-30
- Recover from import errors in Oracle
- When an import runs, it creates tables and loads data before loading other schema objects such as views, synonyms, and sequences. If the import fails after table creation and loading, check out a technique that you can use to continue manually using SQL*Plus. TechRepublic's Oracle newsletter covers automating Oracle...
- Tags: Oracle Corp., SQL, Databases, Scott Stephens, Programming languages, SQL Statement, database, Oracle Tips Newsletter, TechRepublic Inc., Oracle9, Listing C, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-04-26
- << Previous
- page 1 of 1
- Next >>
