VbzCart/docs/queries/qryStk lines Title info

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

Details

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_lines_Title_info AS SELECT

 s.*,
 i.ID_Title

FROM stk_items AS s LEFT JOIN cat_items AS i ON s.ID_Item=i.ID;</mysql> <section end=sql />