Need JOIN template using SQL Server Templates 2005 / 2008 !

Hi,

I have two tables T1 (X, Y) & T2 (A, B) :

SQL
====

SELECT T1.X, T2.B
FROM T1 JOIN T2
WHERE T1.X = T2.A

TQL
====

SELECT <Columns, sysname, >
FROM <Parent_Table, sysname, > JOIN <Child_Table, sysname, >
WHERE <Parent_Table, sysname, >.<PrimaryKey, sysname, > = <Child_Table, sysname, ).<ForeignKey, sysname, >

Now I want to have the aliases like this:

SQL
====

SELECT T1.X, T2.B
FROM T1 u JOIN T2  v
WHERE u.X = v.A

Can you please provide me the JOIN template using SQL Server Templates 2005 / 2008 ?

TQL
====

-- Need here

Thanks
milani_lucieAsked:
Who is Participating?
 
reb73Commented:
Like this, perhaps?
SELECT <Columns, sysname, >
FROM <Parent_Table, sysname, > <Parent_Table_Alias, char(1), > 
JOIN <Child_Table, sysname, > <Child_Table_Alias, char(1), >
WHERE <Parent_Table_Alias, char(1), >.<PrimaryKey, sysname, > = <Child_Table_Alias, char(1), >.<ForeignKey, sysname, >

Open in new window

0
 
8080_DiverCommented:
Try the following:
SELECT T1.X, 
       T2.B
FROM T1 u 
INNER JOIN T2  v
ON    U.X = V.A

Open in new window

0
 
milani_lucieAuthor Commented:
I am expecting TQL. Not an SQL Command.

Thanks
0
 
milani_lucieAuthor Commented:
reb73:

This is what i am looking for. BTW: Where i need to use "sysname" and "Other Data Type (Like Char, Varchar, Int etc..)" ? Can you please explain to me in simple terms ?

Thanks
0
 
reb73Commented:
The second parameter is the datatype for the parameter value.

sysname is a native datatype used to store/reference object identifiers (like table names, view names, procedure names etc)..

Since your alias is not an object name (and I'm presuming that you would tend to use a 1 char alias), I've used char(1).. But you can change this to a datatype/length that's suitable for you (e.g. char(2), varchar(5) etc)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.