* id name type license tax_number phone email address credit_limit status created_at

* id product_id warehouse_id batch_no expiry_date quantity reserved min_qty created_at

* id invoice_no order_id company_id invoice_date subtotal tax total status notes created_at

* id title message type is_read created_at

* id order_no order_type from_company_id to_company_id order_date status subtotal tax total notes created_by created_at

* id order_id product_id quantity price total

* id name scientific_name form strength unit manufacturer barcode cost_price sale_price tax needs_prescription status created_at

* id order_id tracking_no carrier driver vehicle temperature ship_date delivery_date status created_at

* id product_id warehouse_id type quantity reference notes user_id created_at

* id username password full_name role company_id created_at

* id name location type manager capacity status created_at

select table companies inventory invoices notifications orders order_items products shipments stock_movements users warehouses . select column
عرض

criteria

ترتيب	تصاعديا	تنازليا
إضافة كـ	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	نص Another column
	select table companies inventory invoices notifications orders order_items products shipments stock_movements users warehouses .	select column