VbzCart/queries/qryCarts info

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search

Details

  1. REDIRECT Template:l/vc/query, qrySub_Carts_info_data
  • History:
    • 2009-09-08 Created for Special:VbzAdmin

SQL

<mysql>CREATE OR REPLACE VIEW qryCarts_info AS SELECT 

 c.*,
 ItemCount,
 DataCount

FROM (shop_cart AS c 

 LEFT JOIN qrySub_Carts_info_items AS ci ON ci.ID_Cart=c.ID)
 LEFT JOIN qrySub_Carts_info_data as cd ON cd.ID_Cart=c.ID;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCarts_info&oldid=12282"