Nope ... That way my first try, apparently the SQLite engine doesn't know the meaning of the word. I'm finding a few things that I took for granted in mySQL that are missing or hard to figure out in SQLite.
It appears that the first method I mentioned above DOES in fact work. For some reason it just wasn't returning any values in the PhpEd DB window. Coding it the long way into a page got results. Now just have to call just the tables and I'm set.