I am an infant when it comes to DB. I have a table named INVOICE and another table named LINE. The database is part of a textbook and setup properly. (works with all exercises). I am writing a query in sql as follows,
SELECT * FROM INVOICE CROSS JOIN LINE;
getting an error saying that "syntax error in FROM clause." The error comes up for all join statements. Please help.
thanks for the reply. my problem is that I have to use these various join statements in my query code. Not allowed to use alternative syntax. Am I not typing it correctly? I tried a couple of examples from the book and got same syntax error.
Ya, its part of my homework. I e-mailed the teach and she says it should work. All statements with "JOIN" in them are giving me a syntax error. I am able to work around it right now and get desired results but will run into problems later on when I would have to use JOIN statements.