Re: [U2] MySQL query qestion....

2012-07-19 Thread Brian Whitehorn
oun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, 20 July 2012 1:56 AM To: U2 Users Subject: [U2] MySQL query qestion This is specific to MySQL, but could apply to any SQL DB. Is there a way to put the results of one query to be used by anot

Re: [U2] MySQL query qestion....

2012-07-19 Thread George Gallen
2ug.org] On Behalf Of Wols Lists Sent: Thursday, July 19, 2012 12:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] MySQL query qestion My SQL-fu isn't up to much, but my reaction was along the lines of SELECT *, LAST_UPDATED=GET_PROCEDURE() FROM TABLE WHERE LAST_UPDATE > LAS

Re: [U2] MySQL query qestion....

2012-07-19 Thread Kevin King
listserver.u2ug.org] On Behalf Of George Gallen > Sent: 19 July 2012 16:56 > To: U2 Users > Subject: [U2] MySQL query qestion > > This is specific to MySQL, but could apply to any SQL DB. > > Is there a way to put the results of one query to be used by another, > withou

Re: [U2] MySQL query qestion....

2012-07-19 Thread Wols Lists
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: 19 July 2012 16:56 > To: U2 Users > Subject: [U2] MySQL query qestion > > This is specific to MySQL, but could apply to any SQL DB. > > Is there a way to put the results of one query to be use

Re: [U2] MySQL query qestion....

2012-07-19 Thread Brian Leach
alf Of George Gallen Sent: 19 July 2012 16:56 To: U2 Users Subject: [U2] MySQL query qestion This is specific to MySQL, but could apply to any SQL DB. Is there a way to put the results of one query to be used by another, without having that second query run on each Iteration of the sub qu

[U2] MySQL query qestion....

2012-07-19 Thread George Gallen
This is specific to MySQL, but could apply to any SQL DB. Is there a way to put the results of one query to be used by another, without having that second query run on each Iteration of the sub query? Example: SELECT * FROM TABLE WHERE LAST_UPDATE > (SELECT UPDATE_PROCEDURE()); The function UP