Do you have more than 5 records? Try putting an explicit "order by" to ensure you get the same 5 records in every query.
On 1/12/06, Philip Riggs <[EMAIL PROTECTED]> wrote: > I am working in SQLite 3.1.3 on Mac OS X 10.4.4. I keep getting the > following error and am wondering why and what I can do about it? When > I query mukey, cokey, and comppct_r independently I get the correct > result. However, when I query for all three the columns are > misaligned and the first column gets dropped. Is this a problem with > the interface program in OS X's Terminal, or with SQLite itself? > mukey is numeric, comppct_r is numeric, cokey is text. This seems to > be messing up a join.
