Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 29th, 2012  |  syntax: None  |  size: 1.06 KB  |  hits: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. sqlte3 error no such column
  2. sqlite3 salesShare1.db  "
  3.  select
  4.   UsersSale.saleSpecificProduct,
  5.   UsersSale.fAtMall,
  6.   Users.name,
  7.   Users.gender,
  8.   Stores.storeName
  9.  FROM
  10.    UsersSale
  11.     INNER JOIN (Users INNER JOIN Stores ON Users.userID = UsersSale.userID) ON
  12.       Stores.storeID = UsersSale.saleStoreID
  13.  ORDER BY UsersSale.saleID";
  14.        
  15. sqlite3 salesShare1.db  "select * FROM Users ";
  16. 1|hezi|0|||
  17.        
  18. select us.saleSpecificProduct,
  19.    us.fAtMall,u.name,
  20.    u.gender,st.storeName
  21.    from UsersSale us,Users u,Stores st
  22.    where u.userID=us.userID and st.storeID=us.saleStoreID
  23.    order by us.saleID
  24.        
  25. select us.saleSpecificProduct,
  26.    us.fAtMall,u.name,
  27.    u.gender,st.storeName
  28.    from UsersSale us
  29.    inner join Users u
  30.     on u.userID=us.userID
  31.    inner join Stores st
  32.    on st.storeID=us.saleStoreID
  33.    order by us.saleID
  34.        
  35. select
  36.   us.saleSpecificProduct,
  37.   us.fAtMall,
  38.   u.name,
  39.   u.gender,
  40.   s.storeName
  41.  FROM
  42.    UsersSale us
  43.     INNER JOIN Users u ON u.userID = us.userID
  44.     INNER JOIN Stores s ON s.storeID = us.saleStoreID
  45.  
  46.  ORDER BY us.saleID