|
|
Browse by Tags
- 2003
- able
- access
- across
- aggregate
- ambiguously
- ansi
- as400
- business
- cartesian
- complex
- conditional
- count
- cross
- crystal
- cursor
- database
- date
- db2
- delete
- distinct
- domain
- duplicate
- error
- exclude
- explain
- files
- firebird
- Found
- from
- full
- group
- hash
- how
- hql
- i
- ids
- index
- informix
- inner
- insert
- interbase
- invalid
- key
- left
- like
- limit
- lines
- loop
- mac
- many
- merge
- mov
- multiple
- mysql
- nested
- one
- openquery
- operators
- oracle
- order
- out
- outer
- PERFORMANCE
- php
- plan
- ports
- query
- record
- return
- rows
- samba
- same
- sbs
- select
- self
- server
- split
- sql
- sql server
- statement
- subquery
- sum
- sybase
- syntax
- table
- tables
- temp
- three
- top
- T-SQL
- twice
- two
- union
- update
- using
- vista
- vs
- Windows
- xp
-
Select Statement Syntax
I have two tables which I'll call T1 and T2. I am trying to write a select statement that will return every record in T1 where for each T1 record the query returns several fields from T1 and one field from T2 based on a condition (a T2 field equals a T1 field). I tried using a join, but no matter... -
Update statement using inner join
I have two tables ALPHA and BETA. I need to update the BETAID to the ALPHAID. The BETAID is currently set to the ALPHADESC so I am joining on this column. The following update statement works fine in SQL Server: UPDATE BETA SET BETAID= A.ALPHAID FROM TABLE BETA INNER JOIN ALPHA A ON BETAID= A.ALPHADESC... -
T-SQL Update Inner Join Syntax
Quick syntax question I have a TSQL statement that needs to update a field on both tables. The statement is : UPDATE CUSTOMER INNER JOIN PROSPECTIVE_CUSTOMER ON CUSTOMER.CUST_ID = PROSPECTIVE_CUSTOMER.CUST_ID SET PROSPECTIVE_CUSTOMER.PLACE_STATUS = 'A', CUSTOMER.START_DATE = '2006-9-2 00... -
Outer join in sql server query
Can someone please tell me how do I create an outer join between two tables in sql server query. This query gives me an error SELECT DupTable.API, DupTable.[Lease Name], DupTable.[Field Name], DupTable.[Operator Current Name], DupTable.[Date Completion], DupTable.[Pool Status], DupTable.[Historic Production... -
Delete from table based on join with another table
I have the following select select count(*) from SLOG, BRPS where SLOG.task like 'QPRO%' and SLOG.bpdate = BRPS.PREVBRANPRCDATE and SLOG.BR = BRPS.BR ; Now, I want to delete all records from SLOG with the same condition from SLOG, BRPS where SLOG.task like 'QPRO%' and SLOG.bpdate = BRPS... -
Problem with Left Outer Join using MySQL Database -> Error in rowset
Hi All: I am trying to join several Tables in a MySQL Database. I have to join them using two indexes. Whereas this works find when doing an inner join (1:1) its no problem, however, it will only show records from customers, which exist in all 4 Tables, but I need all customers, also the ones which do... -
SQL Reporting - Join Multiple Strings Returned From a Dataset
In the attached screen shot you’ll see that I have “txtProposedInsured” highlighted in blue. This needs to be a list (string) of the applicants separated by semicolons. I’m trying to figure out how to do this. I’ve been playing around with the join statement below but I know this will only return the... -
Inner join using two select statements off the same table
I'm a newbie to this forum and am looking for some help with MySQL. I'm trying to get a count of users that have completed specific activities. For example, I need to be able to run a query that shows me if a person has completed activity 2 and then also if they have completed activity 3. This... -
OUTER JOIN 2 (or more) tables at once
I need to know if it is possible to OUTER JOIN multiple tables at the same time. this would be like OUTER JOINing 2 queries together this code works (but is a pain to update and takes forever to run): SELECT transactions.ID, transactions.ProdID, transactions.RatePlan, transactions.ServArea, products... -
UPDATE one table using JOIN in MySQL 3.23
Hi, I'm trying to update one table where a field in another table is a certain value, but I'm not sure if it's possible in v3.23 and if so, what the syntax would look like. With an example table structure like: t1 (a) t2 (b, a) t3 (c, b, d) I want to run something like UPDATE t1 SET f1 =...