Apparel Software

Powered by Blogger.

My SQL Commands for Select and Delete

Select Command

First go to Query Menus and type commamds line

Select command: select * from but_production where buyer ='Q' and ordr ='C' and colour ='B';

Select command: select * from butt_production where buyer='C' and ordr='A';

Select command: select * from cutt_production where buyer='K' and ordr='Q' and colour='F' and CN=78

Select command: select * from cutt_production where buyer='I' and ordr in( 'F', 'Q');
select * from lot where cbuyer='I' and cordr in( 'F', 'Q');

Select command: select * from cutt_production where buyer='I' and ordr in( 'U', 'V', 'Y', 'I', 'J', 'K', 'L', 'M', 'N', 'W', 'Z', 'E', 'R', 'S', 'P');

Select command: select * from lot where cbuyer='I' and cordr in( 'U', 'V', 'Y', 'I', 'J', 'K', 'L', 'M', 'N', 'W', 'Z', 'E', 'R', 'S', 'P');

Data te gia apply filter e gia data edit kora jai (SID, DATE EDIT)
My SQL Commands for Select and Delete   Lectra Wilcom

Share :

Facebook Twitter Google+ Linkedin
0 Comments "My SQL Commands for Select and Delete"

Back To Top