VbzCart/queries/qryCtg Items updates joinable
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Details
- Requires: qryCtg_Items_updates, qryCat_Titles
- Used by:
SQL
<mysql>CREATE OR REPLACE VIEW qryCtg_Items_updates_joinable AS
SELECT CONCAT_WS('-',u.ID_Title,u.CatSfx) AS IDS_Item, CONCAT_WS('-',t.CatNum,u.CatSfx) AS CatNum, u.* FROM qryCtg_Items_updates AS u LEFT JOIN qryCat_Titles AS t ON u.ID_Title=t.ID;</mysql>