Advice on report

classic Classic list List threaded Threaded
21 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: Advice on report

Patrick Larkin-3
Rick -

Thanks for this.  I have an awesome report now!  I don’t get to exercise my SQL skills often so I get a little fuzzy on some concepts.  

PLEASE NOTE:  My e-mail address has changed to:  [hidden email]
——
Patrick Larkin
Application Management Group
Information Technology
Bethlehem Area School District
https://www.beth.k12.pa.us

On Sep 8, 2014, at 3:52 PM, Rick Draper <[hidden email]> wrote:

> select m.studentnumber
> FROM studentmaster as m
> LEFT JOIN
> studentmaster_yesterday as y
> ON
> m.studentnumber = y.studentnumber
> where
> y.studentnumber IS NULL
>
> Will find new ones
>
> VBR
>
> Rick
>
>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
12