Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- �ȳ��ϼ���.
- �ʺ��� ȥ�� ���۸��ϸ鼭 ������ٰ� ����� ���� �ڽ��ϴ�.
- ����� �Ǹ��ϴ� POS �ý��� ���� �� ����� �ִµ���, ����� ������ �κ��̽� ��ư�� Ŭ���ϸ�,
- Trx(�ŷ���ȣ) Location(�븮��) ��¥/�ð� �մ�̸�
- 00001 Seoul 20091212 ��xx
- 00002 Incheon 20091211 ��xx
- �̷��� ������ �ϰ�Ͱŵ��. �̷��� ����� �������ϴ�.
- SELECT invoices.trx,code_location.name,invoices.date,invoices.time,customers.first_name,customers.last_name
- FROM invoices,products,customers,code_location
- WHERE invoices.sku=products.sku
- AND invoices.customers=customers.no
- AND invoices.code_location=code_location.no
- ORDER BY invoices.no DESC LIMIT 30
- ����, ���� �մԵ�� ����� �� ���� �ϳ��� ��� �� �ƴϴٺ���,
- invoices.sku �� SKU(���ǻ�ǰ�ڵ�) �ѹ��� �� �� �̻� �� ���� �ְŵ��.
- ����
- 1. �ϳ��� �ŷ���ȣ(invoices.trx)�� ���� ���� ���ڵ尡 �� �� �ְ��ؾ��ϰ�
- 2. ���� ����� ����� ����, �ϳ��� �ŷ���ȣ(invoices.trx)�� ������ �ϰ� �����
- ��� �ؾ���� �ڽ��ϴ�. ���� �ϳ��� invoices.trx�� ����� �� �� �̻� ������� ���(invoices.sku�� �� �� �̻�� ���) �׳� ������ �����ϸ� invoices.sku�� �ִ� ���ڵ� ������ŭ �Ȱ��� ���� �ߺ��Ǽ� �����ŵ��.
- ����� ��� ������ �ɱ��? �ƴϸ� ��̺� ��� �����ϸ� ������ �˷��ֽø� �����ϰڽ��ϴ�. ����� ��̺� �� ������ �����İ� �����Ŵٸ� �ʺ���, �ƴµ��� ����� �Դϴ�.^^
- �����մϴ�.
Add Comment
Please, Sign In to add comment