On Thu, 2001-10-11 at 00:03, Feite Brekeveld wrote: > Just, reading it and I always enter these kind of queries like: > > select i.isbn, > t.vendor, > i.store, > i.qty > from bk_inv i, > bk_title t > where > t.vendor = '01672708' and > i.isbn = t.isbn; > > Don't know if it makes a difference but I can imagine that it could because > the t.vendor = '...' limits the possibilities in the first stage.
I have noticed this behaviour too. Is there some sort of guide to use in order to get the query right? Or is this just part of SQL basics? Cheers Tony Grant ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
