Great stuff, ta From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: 14 November 2013 10:51 To: '[email protected]'; '[email protected]' Subject: RE: [mssms] basic query question
Do a left join not an inner join. This will always return all items in your left most view. If you want everything from both columns do a full join. -Daniel Ratliff -----Original Message----- From: Stuart Watret [[email protected]<mailto:[email protected]>] Sent: Thursday, November 14, 2013 05:39 AM Eastern Standard Time To: [email protected]<mailto:[email protected]> Subject: [mssms] basic query question If I do a query for Machine / Last h/w inventory / OU with a criteria of last 30 days for HW Inv and say I get 500 results. If I then add in Top Console User I get 250 results. What I want is the 500 whether or not Top Console User is available; this issue has bugged me for years thought I’d finally ask for a pointer? Cheers Stuart The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
