Welcome, Guest
Username: Password: Remember me

TOPIC: Combining two queries in one event

Combining two queries in one event #987

  • lrousey
  • lrousey's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Does anyone know how to combine two queries into one event so that the two queries are "connected"? I'm trying to create an event that will email vendors with their detail payment information (query 1) and their total payment (query 2).

Thanks.

Laura
The administrator has disabled public write access.

Combining two queries in one event #988

  • jaythegeek
  • jaythegeek's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 1
  • Karma: 0
The way you have this described, a SQL Union would be the best answer. Have you tried that?

I do see from the post on TechTips that this is resolved. Please post your resolution here too. That way this thread is complete.
The administrator has disabled public write access.
The following user(s) said Thank You: gayarubus
Time to create page: 0.029 seconds
Powered by Kunena Forum  Protected by R Antispam