not-exists
Working NOT EXISTS sql query
April 16, 2009 - 9:05am — burningdog- #this query now works. It shows me all vehicles which are available on a particular day
- SELECT node.nid AS nid,
- node.title AS title
- FROM node
- WHERE (node.STATUS <> 0)
EXISTS vs NOT EXISTS as a sql query
April 16, 2009 - 7:39am — burningdog- # I have 3 vehicle nodes: 3, 26, 28. The following query should return ONLY nid 3, but it returns 3, 26, 28.
- SELECT node.nid AS nid
- FROM node
Showing vehicle nodes which don't exist in vehicle_booking nodes
April 16, 2009 - 6:58am — burningdog- #this SQL query has 2 parts. Part 1 shows all vehicles and vehicle bookings nodes (both are CCK types). This returns 4 rows (3 vehicles + 1 vehicle booking)
- SELECT node.nid AS nid,
