Need help from SQL guru !!!!!!!!!

Thread View: comp.lang.basic.visual.database

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Mef Mon, 23 Aug 1999 00:00

#44

Author: Mef
Date: Mon, 23 Aug 1999 00:00

8 lines
1698 bytes

I have some problem with a SQL design.
I have a two tables - money in in first, money out at second and need to see
a result SQL, wich must have a one row per one operation (in or out of
money). If it row show a income - field of debit must to be empty, if it
show a out - field of credit must to be empty too. Any query, what i can
design - multiply a rows' qantity in one table by a rows' qantity of second
and show a repeating of values.
Is it possible to solve this task by using MSAccess? Please, help ...

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads