User Tools

Site Tools


queries

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
queries [2016/12/28 18:40]
tanya Links to database:file_number_numbers_reference changed to employee:sales:sales:windward_software_-_add-on_list:database:file_number_numbers_reference
queries [2017/07/05 11:57] (current)
cliff
Line 1478: Line 1478:
 ==  Set Missing Suppliers To Equal Items Brand Name == ==  Set Missing Suppliers To Equal Items Brand Name ==
 <​code|x>​UPDATE "​Inventry"​ SET Supplier = Brand WHERE supplier = 0.0</​code>​ <​code|x>​UPDATE "​Inventry"​ SET Supplier = Brand WHERE supplier = 0.0</​code>​
 +\\
 +\\
 +\\
 +== View virtual warehouse parts ==
 +<​code|x>​select * from Transfer</​code>​
 +Note: transfer x show the cross reference records for virtual warehouse items that have links to live parts
 +\\
 +\\
 +\\
  
queries.txt ยท Last modified: 2017/07/05 11:57 by cliff