Re: Simple, free RDBMS for VB3/6 with minimal installation footprint

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In article <qd4al2la6oabgm2dsh092pt0aapgnj367k@xxxxxxx>,
kylix_is@xxxxxxxxxxx says...

....

But when I try a query with TWO inner joins, it barfs:

SELECT Customers.CompanyName, Orders.OrderDate, Shippers.CompanyName
FROM Shippers INNER JOIN (Customers INNER JOIN Orders ON
Customers.CustomerID = Orders.CustomerID) ON Shippers.ShipperID =
Orders.ShipVia;

Sqlite/SQLiteSimpleQuery now says:

no such column: Customers.CompanyName

Unless there is a weird undocumented syntax specific to Sqlite that I
don't know about, it apparently cannot parse the two inner joins.

Actually, what you have there is Access-specific join syntax, not ANSI
standard, which is probably what sqlLite uses. Drop the parens, so it
looks like something like (untested!!!):

SELECT Customers.CompanyName, Orders.OrderDate, Shippers.CompanyName
FROM Customers INNER JOIN Orders ON Customers.CustomerID =
Orders.CustomerID INNER JOIN shippers ON Shippers.ShipperID =
Orders.ShipVia;

.....

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
.

Relevant Pages

  • Re: Should be simple but....
    ... FROM Customers C ... INNER JOIN ORDERS O ... INNER JOIN [ORDER DETAILS] OD ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL to Linq - Left, Right and Inner Joins
    ... I'd certainly hope that the query optimiser would do the job there though. ... if the where clause is on an indexed column I'd be *hugely* surprised if the inner join were fully evaluated by SQL server before looking at the index. ... select distinct c.* from customers c inner join orders o ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Multiple Joins Using DAO
    ... Try building the query through the query builder and looking at the SQL ... FROM Employees INNER JOIN (Orders INNER JOIN ON ... FROM Employees INNER JOIN Orders INNER JOIN ON ...
    (microsoft.public.access.formscoding)
  • Re: Simple, free RDBMS for VB3/6 with minimal installation footprint
    ... FROM Shippers INNER JOIN (Customers INNER JOIN Orders ON ... Sqlite/SQLiteSimpleQuery now says: ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL Question
    ... SQL solution given, but when running the program, i get the following error: ... INNER JOIN Orders ON OrderItem.OrderID = Orders.OrderID ...
    (microsoft.public.vb.general.discussion)