Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
New question on SQL help using JOIN
I had to add an additional qualifier in the last where clause which probably slowed things down. Still, it worked and took about 5.5 seconds. Eric Tishler Software Architect Resolute Partners, LLC -
New question on SQL help using JOIN
I just tried this and althogh the query ran in less than one second (wow) is returned 0 rows :-( I modified the query (this time with real table and field names) as ... SELECT * FROM "CCardTransactions" WHERE "CCardTransactions"."CCardTransID" STARTING WITH 'V' AND (... -
New question on SQL help using JOIN
I posted the Need SQL help on query yesterday and got it to work, but the performance is slow. Someone from a different forum suggested the use of a JOIN to improve performance. What they suggested was: SELECT Subset.* FROM Subset LEFT OUTER JOIN Master ON Subset.ID = Master.ID WHERE... -
Need SQL help on query
PHV: It tried this (per your suggestion) and it do not like the keyword IN (as in: NOT IN) rrrkrishnan: I tried your suggestion as well and it worked! Thanks to all ... E Eric Tishler Software Architect Resolute Partners, LLC -
Need SQL help on query
I have been programming for a long time, but I am a relative newbie with SQL. I have two tables with transactions. One table contains ALL transactions, the second table is a subset of the first with only a specific set of transactions. The columns differ between the two tables, but there is...
