Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: donmesserli
- Order by date
-
Two LEFT OUTER JOINs
I am trying to do two LEFT OUTER JOINs. I am using sqlite. The following code DOES NOT work (I get a syntax error)... SELECT a.AutoID, a.Active FROM Automobiles AS a LEFT OUTER JOIN Units AS u ON a.UnitID = u.UnitID WHERE u.UnitNumber>='6' AND u.UnitNumber<'7' LEFT OUTER JOIN ParkingSpots AS p...- donmesserli
- Thread
- Replies: 1
- Forum: ANSI_SQL
