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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using result from DISTINCT SELECT
I want to get some data, from 2 fields, but I don't want to select distinctly by them In my tables I have Table 1: A B TIME Table 2: A B C D E TIME my select is select distinct a, max(2.TIME) from 1 , 2, where 1.a = 2.a and 1.TIME > "2008" GROUP by a The problem I have is I want to get... -
Selecting All rows from one table that is not in the other
It shouldn't be hard to do, I hope. What I want to do is this: select table1.id from table1,table2 where table1.id != table2.id .... I wish it was possible to write like that... but it doesn't I guess I can figure out the reason but anyway how should I do it? PLEAse help... example...
