Thread: Joining two tables
View Single Post
•
•
Join Date: Feb 2008
Posts: 35
Reputation: huangzhi is an unknown quantity at this point 
Solved Threads: 11
huangzhi huangzhi is offline Offline
Light Poster

Re: Joining two tables

 
0
  #3
Nov 24th, 2008
Try this command:
MS SQL Syntax (Toggle Plain Text) 
  1. SELECT	T1.idx, T2.idy, T2.u
  2.   FROM	Table1 T1 RIGHT JOIN Table2 T2 ON
  3. 	T1.idy = T2.Idy AND T1.idx = 'one'
Hence Wijaya
www.ex-Soft.tk
Reply With Quote