Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Access] SQL Query Design
#1
So im sleepy because im having trouble sleeping for long periods of time and this is giving me troubles to think clearly so i need help on this, im have two tables (Histcxc and cxc), both tables are basically the same (They have the same fields) but histcxc contains bills that were already fully payed and cxc contains the bills that needs to be payed/havent been payed fully...

Both Tables share the same automatic Numeration in the field "numfac" (Ergo if the first 3 bills where fully payed and moved to histcxc they must still have the same numfac and the next bill added in cxc must be the number 4)...

Now the problem im having its that i dont know a way to make a query that shows the "numfac" of both tables combined:
[Image: a-4.jpg]

Sorry if i cant make much sense, this lack of sleep its annoying and i have to stay awake for at least 9 more hours :S
#2
UNION
It's not having what you want - It's wanting what you've got.
#3
Yup works like a charm now, thx eos.

Also the guide i was reading on SQL commands did have the union but it was hidden somewhere after the middle of the guide with tiny letters, too hard to see with sleepy eyes :S


Forum Jump:


Users browsing this thread: 1 Guest(s)