IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Is this what you want?
Post #75,678
by ChrisR
1/20/03 12:48:58 PM
Reply
New Is this what you want? 
\nSELECT \n   *,\n   (SELECT LASTNAME + ', ' + FIRSTNAME FROM USERS WHERE USERID = tab.ASSIGNEDTO),\n   (SELECT LASTNAME + ', ' + FIRSTNAME FROM USERS WHERE USERID = tab.OPENEDBY),\n   (SELECT LASTNAME + ', ' + FIRSTNAME FROM USERS WHERE USERID = tab.REQUESTEDBY)\nFROM TICKETS tab\nWHERE ASSIGNEDTO=1\n
Post #75,680
by inthane-chan
Picture of inthane-chan
1/20/03 12:50:00 PM
Reply
New That looks good...
Any deity worthy of a graven image can cobble up a working universe complete with fake fossils in under a week - hey, if you're not omnipotent, there's no real point in being a god. But to start with a big ball of elementary particles and end up with the duckbill platypus without constant twiddling requires a degree of subtlety and the ability to Think Things Through: exactly the qualities I'm looking for when I'm shopping for a Supreme Being.
     Trying to build a query (n00b) - (inthane-chan) - (20) - Jan. 20, 2003, 12:30:44 PM EST
         Off the top of my head - (JayMehaffey) - (8) - Jan. 20, 2003, 12:40:17 PM EST
             Blew my SQL engine... - (inthane-chan) - Jan. 20, 2003, 12:49:05 PM EST
             What is this INNER JOIN nonsense? - (ben_tilly) - (6) - Jan. 20, 2003, 01:14:46 PM EST
                 Why do you say that? - (JayMehaffey) - (5) - Jan. 20, 2003, 07:03:15 PM EST
                     /me relearns the value of double-checking references... - (ben_tilly) - (4) - Jan. 20, 2003, 07:23:54 PM EST
                         It works in MS SQL Server as well. - (orion) - Jan. 20, 2003, 08:21:58 PM EST
                         Actually, Oracle also uses the JOIN syntax, as of version... - (CRConrad) - (1) - Jan. 21, 2003, 03:05:52 AM EST
                             And that may be where my bias is from - (ben_tilly) - Jan. 21, 2003, 07:35:19 AM EST
                         I must be an exception. - (static) - Jan. 21, 2003, 06:18:46 AM EST
         Is this what you want? - (ChrisR) - (1) - Jan. 20, 2003, 12:48:58 PM EST
             That looks good... -NT - (inthane-chan) - Jan. 20, 2003, 12:50:00 PM EST
         Here I come to save the day - (orion) - Jan. 20, 2003, 12:50:13 PM EST
         Fixed. - (inthane-chan) - (1) - Jan. 20, 2003, 01:08:34 PM EST
             We posted around the same time - (orion) - Jan. 20, 2003, 08:23:07 PM EST
         this is how I'd do it - (SpiceWare) - (5) - Jan. 20, 2003, 02:06:41 PM EST
             Do you do that... - (inthane-chan) - (3) - Jan. 20, 2003, 02:06:00 PM EST
                 As to whether you *should* do that - (drewk) - Jan. 20, 2003, 02:24:33 PM EST
                 how's it guaranteed? - (SpiceWare) - (1) - Jan. 20, 2003, 02:30:06 PM EST
                     Enforced by DB. -NT - (inthane-chan) - Jan. 20, 2003, 02:53:02 PM EST
             This is how I'd do it - (drewk) - Jan. 20, 2003, 02:19:48 PM EST

Ashes to Ashton, dust to debris.
58 ms