Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smithysrat
Starting Member
3 Posts |
 Posted - 2007-09-28 : 08:43:17
|
| Hi All,I'm trying to create a query and having a few problems getting it right.where there are records present in table, using bform.document.ref_bform related to bform.event_log.ref_bform I need to list all of the records in bform.document where there is NOT a related "INV" event in bform.event_log.typeThere may be other event types related but I am not interested in these.Please help!Thanks Muchly! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-28 : 09:16:43
|
You can try either NOT EXISTS or LEFT JOIN to solve your dilemma.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-09-28 : 09:51:16
|
or, if using 2005, EXCEPT might help [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
Query Help