RSS Forums RSS
Please support our MySQL advertiser: Programming Forums

select with outer join

Join Date: Jul 2005
Location: Dallas, TX
Posts: 482
Reputation: campkev is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 19
campkev campkev is offline Offline
Posting Pro in Training

Re: select with outer join

  #2  
Apr 19th, 2006
don't use mysql buth this works in ms-sql:

select t1.xid,t1.data1, t2.data2 from t1
right join t2 on
t1.xid = t2.xid
Last edited by campkev : Apr 19th, 2006 at 2:23 pm. Reason: correction
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 2:49 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC